DBA Data[Home] [Help]

APPS.PAY_ELEMENT_EXTRACT_PKG dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 886: pay_element_classifications pec

882: select distinct nvl(pettl.reporting_name,pettl.element_name)
883: from pay_element_types_f pet,
884: pay_element_types_f_tl pettl,
885: PAY_SUB_CLASSIFICATION_RULES_F scr,
886: pay_element_classifications pec
887: where scr.element_type_id = pet.element_type_id
888: and pec.classification_id = cp_element_classification_id
889: and pec.classification_id = scr.classification_id
890: and cp_business_group_id = nvl(pet.business_group_id,

Line 1376: pay_element_classifications pec

1372: pay_input_values_f piv,
1373: pay_run_result_values prrv,
1374: pay_run_results prr,
1375: pay_input_values_f_tl pivtl,
1376: pay_element_classifications pec
1377: where pivtl.name = ''Pay Value''
1378: and pivtl.language = ''US''
1379: and pivtl.input_value_id = piv.input_value_id
1380: and prrv.input_value_id = piv.input_value_id

Line 1415: pay_element_classifications pec,

1411: pay_input_values_f piv,
1412: pay_run_result_values prrv,
1413: pay_run_results prr,
1414: pay_input_values_f_tl pivtl,
1415: pay_element_classifications pec,
1416: pay_sub_classification_rules_f scr
1417: where pivtl.name = ''Pay Value''
1418: and pivtl.language = ''US''
1419: and pivtl.input_value_id = piv.input_value_id