DBA Data[Home] [Help]

APPS.PAY_INTERPRETER_PKG dependencies on PQH_RATE_MATRIX_RATES_F

Line 4817: ,pqh_rate_matrix_rates_f prmr

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

Line 4827: ,pqh_rate_matrix_rates_f prmr

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

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

4857: l_valid_event := 'Y';
4858: --
4859: end if;
4860: --
4861: elsif (p_table_name = 'PQH_RATE_MATRIX_RATES_F') then
4862:
4863: l_valid_event := 'N';
4864:
4865: for grrec in validate_rate_by_criteria(p_assignment_id,p_surrogate_key) loop