eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_RBC_RATE_RETRIEVAL dependencies on PQH_CRITERIA_RATE_DEFN

Line 409: l_pref_rate_cd pqh_criteria_rate_defn.preferential_rate_cd%type;

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;
410: l_pref_rate_rule pqh_criteria_rate_defn.preferential_rate_rule%type;
411: l_proc varchar2(72) := g_package||'calculate_preferential_rate';
412: --
413: Cursor csr_rate_type is

Line 410: l_pref_rate_rule pqh_criteria_rate_defn.preferential_rate_rule%type;

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;
410: l_pref_rate_rule pqh_criteria_rate_defn.preferential_rate_rule%type;
411: l_proc varchar2(72) := g_package||'calculate_preferential_rate';
412: --
413: Cursor csr_rate_type is
414: Select preferential_rate_cd, preferential_rate_rule

Line 415: from pqh_criteria_rate_defn

411: l_proc varchar2(72) := g_package||'calculate_preferential_rate';
412: --
413: Cursor csr_rate_type is
414: Select preferential_rate_cd, preferential_rate_rule
415: from pqh_criteria_rate_defn
416: Where criteria_rate_defn_id = p_crit_rt_defn_id;
417: --
418: Begin
419: --

Line 781: l_ref_period_cd pqh_criteria_rate_defn.reference_period_cd%type;

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;
784: l_rounding_cd pqh_criteria_rate_defn.rounding_cd%type;
785: l_rounding_rule pqh_criteria_rate_defn.rounding_rule%type;

Line 782: l_rate_calc_cd pqh_criteria_rate_defn.rate_calc_cd%type;

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;
784: l_rounding_cd pqh_criteria_rate_defn.rounding_cd%type;
785: l_rounding_rule pqh_criteria_rate_defn.rounding_rule%type;
786: l_uom pqh_criteria_rate_defn.uom%type;

Line 783: l_rate_calc_rule pqh_criteria_rate_defn.rate_calc_rule%type;

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;
784: l_rounding_cd pqh_criteria_rate_defn.rounding_cd%type;
785: l_rounding_rule pqh_criteria_rate_defn.rounding_rule%type;
786: l_uom pqh_criteria_rate_defn.uom%type;
787: l_currency_code pqh_criteria_rate_defn.currency_code%type;

Line 784: l_rounding_cd pqh_criteria_rate_defn.rounding_cd%type;

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;
784: l_rounding_cd pqh_criteria_rate_defn.rounding_cd%type;
785: l_rounding_rule pqh_criteria_rate_defn.rounding_rule%type;
786: l_uom pqh_criteria_rate_defn.uom%type;
787: l_currency_code pqh_criteria_rate_defn.currency_code%type;
788: l_reference_period_cd pqh_criteria_rate_defn.reference_period_cd%type;

Line 785: l_rounding_rule pqh_criteria_rate_defn.rounding_rule%type;

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;
784: l_rounding_cd pqh_criteria_rate_defn.rounding_cd%type;
785: l_rounding_rule pqh_criteria_rate_defn.rounding_rule%type;
786: l_uom pqh_criteria_rate_defn.uom%type;
787: l_currency_code pqh_criteria_rate_defn.currency_code%type;
788: l_reference_period_cd pqh_criteria_rate_defn.reference_period_cd%type;
789: --

Line 786: l_uom pqh_criteria_rate_defn.uom%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;
784: l_rounding_cd pqh_criteria_rate_defn.rounding_cd%type;
785: l_rounding_rule pqh_criteria_rate_defn.rounding_rule%type;
786: l_uom pqh_criteria_rate_defn.uom%type;
787: l_currency_code pqh_criteria_rate_defn.currency_code%type;
788: l_reference_period_cd pqh_criteria_rate_defn.reference_period_cd%type;
789: --
790: l_dflt_rate pqh_rate_matrix_rates_f.rate_value%type := 0;

Line 787: l_currency_code pqh_criteria_rate_defn.currency_code%type;

783: l_rate_calc_rule pqh_criteria_rate_defn.rate_calc_rule%type;
784: l_rounding_cd pqh_criteria_rate_defn.rounding_cd%type;
785: l_rounding_rule pqh_criteria_rate_defn.rounding_rule%type;
786: l_uom pqh_criteria_rate_defn.uom%type;
787: l_currency_code pqh_criteria_rate_defn.currency_code%type;
788: l_reference_period_cd pqh_criteria_rate_defn.reference_period_cd%type;
789: --
790: l_dflt_rate pqh_rate_matrix_rates_f.rate_value%type := 0;
791: l_min_rate pqh_rate_matrix_rates_f.min_rate_value%type := 0;

Line 788: l_reference_period_cd pqh_criteria_rate_defn.reference_period_cd%type;

784: l_rounding_cd pqh_criteria_rate_defn.rounding_cd%type;
785: l_rounding_rule pqh_criteria_rate_defn.rounding_rule%type;
786: l_uom pqh_criteria_rate_defn.uom%type;
787: l_currency_code pqh_criteria_rate_defn.currency_code%type;
788: l_reference_period_cd pqh_criteria_rate_defn.reference_period_cd%type;
789: --
790: l_dflt_rate pqh_rate_matrix_rates_f.rate_value%type := 0;
791: l_min_rate pqh_rate_matrix_rates_f.min_rate_value%type := 0;
792: l_mid_rate pqh_rate_matrix_rates_f.mid_rate_value%type := 0;

Line 799: l_t_rate_calc_cd pqh_criteria_rate_defn.rate_calc_cd%type;

795: l_t_dflt_rate pqh_rate_matrix_rates_f.rate_value%type := 0;
796: l_t_min_rate pqh_rate_matrix_rates_f.min_rate_value%type := 0;
797: l_t_mid_rate pqh_rate_matrix_rates_f.mid_rate_value%type := 0;
798: l_t_max_rate pqh_rate_matrix_rates_f.max_rate_value%type := 0;
799: l_t_rate_calc_cd pqh_criteria_rate_defn.rate_calc_cd%type;
800: l_t_rate_calc_rule pqh_criteria_rate_defn.rate_calc_rule%type;
801: l_t_rounding_cd pqh_criteria_rate_defn.rounding_cd%type;
802: l_t_rounding_rule pqh_criteria_rate_defn.rounding_rule%type;
803: l_t_ref_period_cd pqh_criteria_rate_defn.reference_period_cd%type;

Line 800: l_t_rate_calc_rule pqh_criteria_rate_defn.rate_calc_rule%type;

796: l_t_min_rate pqh_rate_matrix_rates_f.min_rate_value%type := 0;
797: l_t_mid_rate pqh_rate_matrix_rates_f.mid_rate_value%type := 0;
798: l_t_max_rate pqh_rate_matrix_rates_f.max_rate_value%type := 0;
799: l_t_rate_calc_cd pqh_criteria_rate_defn.rate_calc_cd%type;
800: l_t_rate_calc_rule pqh_criteria_rate_defn.rate_calc_rule%type;
801: l_t_rounding_cd pqh_criteria_rate_defn.rounding_cd%type;
802: l_t_rounding_rule pqh_criteria_rate_defn.rounding_rule%type;
803: l_t_ref_period_cd pqh_criteria_rate_defn.reference_period_cd%type;
804: l_t_uom pqh_criteria_rate_defn.uom%type;

Line 801: l_t_rounding_cd pqh_criteria_rate_defn.rounding_cd%type;

797: l_t_mid_rate pqh_rate_matrix_rates_f.mid_rate_value%type := 0;
798: l_t_max_rate pqh_rate_matrix_rates_f.max_rate_value%type := 0;
799: l_t_rate_calc_cd pqh_criteria_rate_defn.rate_calc_cd%type;
800: l_t_rate_calc_rule pqh_criteria_rate_defn.rate_calc_rule%type;
801: l_t_rounding_cd pqh_criteria_rate_defn.rounding_cd%type;
802: l_t_rounding_rule pqh_criteria_rate_defn.rounding_rule%type;
803: l_t_ref_period_cd pqh_criteria_rate_defn.reference_period_cd%type;
804: l_t_uom pqh_criteria_rate_defn.uom%type;
805: l_t_currency_code pqh_criteria_rate_defn.currency_code%type;

Line 802: l_t_rounding_rule pqh_criteria_rate_defn.rounding_rule%type;

798: l_t_max_rate pqh_rate_matrix_rates_f.max_rate_value%type := 0;
799: l_t_rate_calc_cd pqh_criteria_rate_defn.rate_calc_cd%type;
800: l_t_rate_calc_rule pqh_criteria_rate_defn.rate_calc_rule%type;
801: l_t_rounding_cd pqh_criteria_rate_defn.rounding_cd%type;
802: l_t_rounding_rule pqh_criteria_rate_defn.rounding_rule%type;
803: l_t_ref_period_cd pqh_criteria_rate_defn.reference_period_cd%type;
804: l_t_uom pqh_criteria_rate_defn.uom%type;
805: l_t_currency_code pqh_criteria_rate_defn.currency_code%type;
806: l_t_reference_period_cd pqh_criteria_rate_defn.reference_period_cd%type;

Line 803: l_t_ref_period_cd pqh_criteria_rate_defn.reference_period_cd%type;

799: l_t_rate_calc_cd pqh_criteria_rate_defn.rate_calc_cd%type;
800: l_t_rate_calc_rule pqh_criteria_rate_defn.rate_calc_rule%type;
801: l_t_rounding_cd pqh_criteria_rate_defn.rounding_cd%type;
802: l_t_rounding_rule pqh_criteria_rate_defn.rounding_rule%type;
803: l_t_ref_period_cd pqh_criteria_rate_defn.reference_period_cd%type;
804: l_t_uom pqh_criteria_rate_defn.uom%type;
805: l_t_currency_code pqh_criteria_rate_defn.currency_code%type;
806: l_t_reference_period_cd pqh_criteria_rate_defn.reference_period_cd%type;
807: --

Line 804: l_t_uom pqh_criteria_rate_defn.uom%type;

800: l_t_rate_calc_rule pqh_criteria_rate_defn.rate_calc_rule%type;
801: l_t_rounding_cd pqh_criteria_rate_defn.rounding_cd%type;
802: l_t_rounding_rule pqh_criteria_rate_defn.rounding_rule%type;
803: l_t_ref_period_cd pqh_criteria_rate_defn.reference_period_cd%type;
804: l_t_uom pqh_criteria_rate_defn.uom%type;
805: l_t_currency_code pqh_criteria_rate_defn.currency_code%type;
806: l_t_reference_period_cd pqh_criteria_rate_defn.reference_period_cd%type;
807: --
808: l_cnt number := 0;

Line 805: l_t_currency_code pqh_criteria_rate_defn.currency_code%type;

801: l_t_rounding_cd pqh_criteria_rate_defn.rounding_cd%type;
802: l_t_rounding_rule pqh_criteria_rate_defn.rounding_rule%type;
803: l_t_ref_period_cd pqh_criteria_rate_defn.reference_period_cd%type;
804: l_t_uom pqh_criteria_rate_defn.uom%type;
805: l_t_currency_code pqh_criteria_rate_defn.currency_code%type;
806: l_t_reference_period_cd pqh_criteria_rate_defn.reference_period_cd%type;
807: --
808: l_cnt number := 0;
809: l_t_cnt number := 0;

Line 806: l_t_reference_period_cd pqh_criteria_rate_defn.reference_period_cd%type;

802: l_t_rounding_rule pqh_criteria_rate_defn.rounding_rule%type;
803: l_t_ref_period_cd pqh_criteria_rate_defn.reference_period_cd%type;
804: l_t_uom pqh_criteria_rate_defn.uom%type;
805: l_t_currency_code pqh_criteria_rate_defn.currency_code%type;
806: l_t_reference_period_cd pqh_criteria_rate_defn.reference_period_cd%type;
807: --
808: l_cnt number := 0;
809: l_t_cnt number := 0;
810: --

Line 828: from pqh_criteria_rate_defn

824: and business_group_id = p_business_group_id;
825: --
826: Cursor csr_crd_details(p_crit_rt_defn_id in number) is
827: Select rate_calc_cd, rate_calc_rule,rounding_cd,rounding_rule,uom,currency_code,reference_period_cd
828: from pqh_criteria_rate_defn
829: Where criteria_rate_defn_id = p_crit_rt_defn_id
830: and business_group_id = p_business_group_id;
831: --
832: l_proc varchar2(72) := g_package||'calculate_crit_rate_defn_rt';

Line 1385: l_crit_rt_defn_id pqh_criteria_rate_defn.criteria_rate_defn_id%type;

1381: from per_all_assignments_f
1382: Where assignment_id = p_assignment_id
1383: and p_effective_date between effective_start_date and effective_end_date;
1384: --
1385: l_crit_rt_defn_id pqh_criteria_rate_defn.criteria_rate_defn_id%type;
1386: l_assignment_id per_all_assignments_f.assignment_id%type;
1387: l_person_id per_all_people_f.person_id%type;
1388: l_proc varchar2(72) := g_package||'determine_rbc_rate';
1389: --

Line 1522: l_crit_rt_defn_id pqh_criteria_rate_defn.criteria_rate_defn_id%type;

1518: from per_all_assignments_f
1519: Where assignment_id = p_assignment_id
1520: and p_effective_date between effective_start_date and effective_end_date;
1521: --
1522: l_crit_rt_defn_id pqh_criteria_rate_defn.criteria_rate_defn_id%type;
1523: l_criteria_list pqh_popl_criteria_ovrrd.g_crit_ovrrd_val_tbl;
1524: l_assignment_id per_all_assignments_f.assignment_id%type;
1525: l_person_id per_all_people_f.person_id%type;
1526: l_proc varchar2(72) := g_package||'determine_rbc_rate';

Line 1681: l_crit_rt_defn_id pqh_criteria_rate_defn.criteria_rate_defn_id%type;

1677: p_mid_rate OUT nocopy number,
1678: p_max_rate OUT nocopy number,
1679: p_rate OUT nocopy number) is
1680: --
1681: l_crit_rt_defn_id pqh_criteria_rate_defn.criteria_rate_defn_id%type;
1682: l_criteria_list pqh_popl_criteria_ovrrd.g_crit_ovrrd_val_tbl;
1683: --
1684: cursor csr_linked_crd is
1685: Select criteria_rate_defn_id