DBA Data[Home] [Help]

APPS.PAY_INTERPRETER_PKG dependencies on PQH_CRITERIA_RATE_ELEMENTS

Line 4816: ,pqh_criteria_rate_elements pcre

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

Line 4825: ,pqh_criteria_rate_elements pcre

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