DBA Data[Home] [Help]

APPS.PAY_PQH_RBC dependencies on PQH_RATE_MATRIX_RATES_F

Line 73: ,pqh_rate_matrix_rates_f prmr

69: where exists (
70: select 'Y'
71: from pay_element_entries_f pee
72: ,pqh_criteria_rate_elements pcre
73: ,pqh_rate_matrix_rates_f prmr
74: where pee.element_entry_id=pay_interpreter_pkg.g_ee_id
75: and pcre.element_type_id=pee.element_type_id
76: and pcre.criteria_rate_defn_id=prmr.criteria_rate_defn_id
77: and prmr.rate_matrix_rate_id=pay_interpreter_pkg.g_object_key

Line 85: pqh_rate_matrix_rates_f prmr

81: Select 'Y'
82: from pay_element_entries_f pee,
83: pqh_criteria_rate_elements pcre,
84: pqh_criteria_rate_factors pcrf,
85: pqh_rate_matrix_rates_f prmr
86: where pee.element_entry_id=pay_interpreter_pkg.g_ee_id
87: and pcre.element_type_id=pee.element_type_id
88: and pcre.criteria_rate_defn_id = pcrf.criteria_rate_defn_id
89: and pcrf.parent_criteria_rate_defn_id = prmr.criteria_rate_defn_id