DBA Data[Home] [Help]

APPS.PAY_INTERPRETER_PKG dependencies on PQH_CRITERIA_RATE_ELEMENTS

Line 4818: ,pqh_criteria_rate_elements pcre

4814: from dual
4815: where exists (
4816: select '' chk
4817: from pay_element_entries_f pee
4818: ,pqh_criteria_rate_elements pcre
4819: ,pqh_rate_matrix_rates_f prmr
4820: where pee.assignment_id=p_assignment_id
4821: and pcre.element_type_id=pee.element_type_id
4822: and pcre.criteria_rate_defn_id=prmr.criteria_rate_defn_id

Line 4827: ,pqh_criteria_rate_elements pcre

4823: and prmr.rate_matrix_rate_id=p_surrogate_key)
4824: or exists (
4825: select '' chk
4826: from pay_element_entries_f pee
4827: ,pqh_criteria_rate_elements pcre
4828: ,pqh_criteria_rate_factors pcrf
4829: ,pqh_rate_matrix_rates_f prmr
4830: where pee.assignment_id=p_assignment_id
4831: and pcre.element_type_id=pee.element_type_id