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
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