DBA Data[Home] [Help]

APPS.PAY_PQH_RBC dependencies on PQH_CRITERIA_RATE_ELEMENTS

Line 72: ,pqh_criteria_rate_elements pcre

68: from dual
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

Line 83: pqh_criteria_rate_elements pcre,

79: and pee.effective_start_date <= prmr.effective_end_date)
80: or exists (
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