DBA Data[Home] [Help]

APPS.PAY_ELEMENT_EXTRACT_PKG dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 895: pay_element_classifications pec

891: select distinct nvl(pettl.reporting_name,pettl.element_name)
892: from pay_element_types_f pet,
893: pay_element_types_f_tl pettl,
894: PAY_SUB_CLASSIFICATION_RULES_F scr,
895: pay_element_classifications pec
896: where scr.element_type_id = pet.element_type_id
897: and pec.classification_id = cp_element_classification_id
898: and pec.classification_id = scr.classification_id
899: and cp_business_group_id = nvl(pet.business_group_id,

Line 1388: pay_element_classifications pec

1384: pay_input_values_f piv,
1385: pay_run_result_values prrv,
1386: pay_run_results prr,
1387: pay_input_values_f_tl pivtl,
1388: pay_element_classifications pec
1389: where piv.name = ''Pay Value''
1390: and pivtl.input_value_id = piv.input_value_id
1391: and prrv.input_value_id = piv.input_value_id
1392: and piv.element_type_id = pet.element_type_id

Line 1425: pay_element_classifications pec,

1421: pay_input_values_f piv,
1422: pay_run_result_values prrv,
1423: pay_run_results prr,
1424: pay_input_values_f_tl pivtl,
1425: pay_element_classifications pec,
1426: pay_sub_classification_rules_f scr
1427: where piv.name = ''Pay Value''
1428: and pivtl.input_value_id = piv.input_value_id
1429: and prrv.input_value_id = piv.input_value_id