DBA Data[Home] [Help]

APPS.PAY_INTERPRETER_PKG dependencies on PQH_RATE_MATRIX_RATES_F

Line 4819: ,pqh_rate_matrix_rates_f prmr

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
4823: and prmr.rate_matrix_rate_id=p_surrogate_key)

Line 4829: ,pqh_rate_matrix_rates_f prmr

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
4832: and pcre.criteria_rate_defn_id = pcrf.criteria_rate_defn_id
4833: and pcrf.parent_criteria_rate_defn_id = prmr.criteria_rate_defn_id

Line 4900: elsif (p_table_name = 'PQH_RATE_MATRIX_RATES_F') then

4896: l_valid_event := 'Y';
4897: --
4898: end if;
4899: --
4900: elsif (p_table_name = 'PQH_RATE_MATRIX_RATES_F') then
4901:
4902: l_valid_event := 'N';
4903:
4904: for grrec in validate_rate_by_criteria(p_assignment_id,p_surrogate_key) loop