APPS.PQH_RBC_RATE_RETRIEVAL dependencies on BEN_EVALUATE_RATE_MATRIX

Line 201: p_eligible_rates IN ben_evaluate_rate_matrix.rate_tab,

197: -- Function to return the preferential rate for a person, for a given rate type.
198: --
199: Procedure apply_pref_rate_code
200: (p_crit_rt_defn_id IN number,
201: p_eligible_rates IN ben_evaluate_rate_matrix.rate_tab,
202: p_effective_date IN date,
203: p_preferential_rate_cd IN varchar2,
204: p_preferential_rate_rl IN varchar2,
205: p_preferential_min_rt OUT nocopy number,

Line 394: p_eligible_rates IN ben_evaluate_rate_matrix.rate_tab,

390: -- Function to return the preferential rate for a person, for a given rate type.
391: --
392: Procedure calculate_preferential_rate
393: (p_crit_rt_defn_id IN number,
394: p_eligible_rates IN ben_evaluate_rate_matrix.rate_tab,
395: p_effective_date IN date,
396: p_rate_factors OUT nocopy g_rbc_factor_tbl,
397: p_rate_factor_cnt OUT nocopy number,
398: p_preferential_min_rt OUT nocopy number,

Line 405: l_temp_rate_tab ben_evaluate_rate_matrix.rate_tab;

401: p_preferential_rt OUT nocopy number)
402: is
403: --
404: l_rt_counter number:= 0;
405: l_temp_rate_tab ben_evaluate_rate_matrix.rate_tab;
406: l_highest_level pqh_rate_matrix_nodes.level_number%type;
407: rec_no number;
408: l_cnt number:= 0;
409: l_pref_rate_cd pqh_criteria_rate_defn.preferential_rate_cd%type;

Line 533: l_elig_rates ben_evaluate_rate_matrix.rate_tab;

529: p_max_rate OUT nocopy number,
530: p_rate OUT nocopy number)
531: is
532: --
533: l_elig_rates ben_evaluate_rate_matrix.rate_tab;
534: l_pref_rate pqh_rate_matrix_rates_f.rate_value%type;
535: l_min_rate pqh_rate_matrix_rates_f.min_rate_value%type;
536: l_mid_rate pqh_rate_matrix_rates_f.mid_rate_value%type;
537: l_max_rate pqh_rate_matrix_rates_f.max_rate_value%type;

Line 560: ben_evaluate_rate_matrix.determine_rate

556: p_threads => null,
557: p_max_errors => null,
558: p_benefit_action_id => null);
559: --
560: ben_evaluate_rate_matrix.determine_rate
561: (p_person_id => p_person_id,
562: p_assignment_id => p_assignment_id,
563: p_criteria_rate_defn_id => p_crit_rt_defn_id,
564: p_effective_date => p_effective_date,

Line 779: l_parent_rates ben_evaluate_rate_matrix.rate_tab;

775: p_max_rate OUT nocopy number,
776: p_rate OUT nocopy number)
777: is
778: --
779: l_parent_rates ben_evaluate_rate_matrix.rate_tab;
780: --
781: l_ref_period_cd pqh_criteria_rate_defn.reference_period_cd%type;
782: l_rate_calc_cd pqh_criteria_rate_defn.rate_calc_cd%type;
783: l_rate_calc_rule pqh_criteria_rate_defn.rate_calc_rule%type;