DBA Data[Home] [Help]

APPS.PAY_FI_ARCHIVE_PYSA dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 180: ,pay_element_classifications pec

176: ,hoi.org_information7 element_narrative
177: ,pec.classification_name
178: ,piv.uom
179: FROM hr_organization_information hoi
180: ,pay_element_classifications pec
181: ,pay_element_types_f pet
182: ,pay_input_values_f piv
183: WHERE hoi.organization_id = p_bus_grp_id
184: AND hoi.org_information_context = 'Business Group:Payslip Info'

Line 1073: , pay_element_classifications classification

1069: ,iv.uom uom
1070: FROM pay_element_types_f et
1071: , pay_element_types_f_tl pettl
1072: , pay_input_values_f iv
1073: , pay_element_classifications classification
1074: WHERE et.element_type_id = iv.element_type_id
1075: AND et.element_type_id = pettl.element_type_id
1076: AND pettl.language = USERENV('LANG')
1077: AND iv.name = 'Pay Value'

Line 1105: , pay_element_classifications classification

1101: ,iv.uom uom
1102: FROM pay_element_types_f et
1103: , pay_element_types_f_tl pettl
1104: , pay_input_values_f iv
1105: , pay_element_classifications classification
1106: WHERE et.element_type_id = iv.element_type_id
1107: AND et.element_type_id = pettl.element_type_id
1108: AND pettl.language = USERENV('LANG')
1109: AND iv.name = 'Pay Value'

Line 1593: ,pay_element_classifications pec

1589: ,hoi.org_information7 element_narrative
1590: ,pec.classification_name
1591: ,piv.uom
1592: FROM hr_organization_information hoi
1593: ,pay_element_classifications pec
1594: ,pay_element_types_f pet
1595: ,pay_input_values_f piv
1596: WHERE hoi.organization_id = p_bus_grp_id
1597: AND hoi.org_information_context = 'Business Group:Payslip Info'

Line 2726: , pay_element_classifications classification

2722: ,iv.uom uom
2723: FROM pay_element_types_f et
2724: , pay_element_types_f_tl pettl
2725: , pay_input_values_f iv
2726: , pay_element_classifications classification
2727: WHERE et.element_type_id = iv.element_type_id
2728: AND et.element_type_id = pettl.element_type_id
2729: AND pettl.language = USERENV('LANG')
2730: AND iv.name = 'Pay Value'

Line 2761: , pay_element_classifications classification

2757: ,iv.uom uom
2758: FROM pay_element_types_f et
2759: , pay_element_types_f_tl pettl
2760: , pay_input_values_f iv
2761: , pay_element_classifications classification
2762: WHERE et.element_type_id = iv.element_type_id
2763: AND et.element_type_id = pettl.element_type_id
2764: AND pettl.language = USERENV('LANG')
2765: AND iv.name = 'Pay Value'