aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
fn_yield_effective_rate
Parameters
Name
Type
Mode
i_rate_id
integer
IN
i_rate_date
date
IN
Definition
DECLARE v record; BEGIN SELECT rd.yield_adjust_type, rd.yield_adjust_value, rd.yield_override, COALESCE(rd.rate_amount, det.rate_amount, rt.room_rate) AS base, COALESCE(p.min_rate, rt.min_rate, 0::public.t_money) AS min_rate, p.days INTO v FROM public.rate_daily rd JOIN public.rate_details det ON det.rate_id = rd.rate_id JOIN public.rate_plan p ON p.id = det.rateplan_id JOIN public.room_type rt ON rt.id = det.roomtype_id WHERE rd.rate_id = i_rate_id AND rd.rate_date = i_rate_date; IF NOT FOUND THEN RETURN NULL; END IF; RETURN public.fn_apply_yield(v.base, v.yield_adjust_type, v.yield_adjust_value, v.yield_override, v.min_rate, i_rate_date, v.days); END