DBA Data[Home] [Help]

APPS.PAY_KW_ARCHIVE dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 209: ,pay_element_classifications pec

205: ,hoi.org_information3 element_narrative
206: ,pec.classification_name
207: ,piv.uom
208: FROM hr_organization_information hoi
209: ,pay_element_classifications pec
210: ,pay_element_types_f pet
211: ,pay_input_values_f piv
212: WHERE hoi.organization_id = p_bus_grp_id
213: AND hoi.org_information_context = 'KW_PAYSLIP_ELEMENTS'

Line 1307: , pay_element_classifications classification

1303: ,iv.uom uom
1304: FROM pay_element_types_f et
1305: , pay_element_types_f_tl pettl
1306: , pay_input_values_f iv
1307: , pay_element_classifications classification
1308: WHERE et.element_type_id = iv.element_type_id
1309: AND et.element_type_id = pettl.element_type_id
1310: AND pettl.language = USERENV('LANG')
1311: AND iv.name = 'Pay Value'

Line 1333: , pay_element_classifications classification

1329: ,iv.uom uom
1330: FROM pay_element_types_f et
1331: , pay_element_types_f_tl pettl
1332: , pay_input_values_f iv
1333: , pay_element_classifications classification
1334: WHERE et.element_type_id = iv.element_type_id
1335: AND et.element_type_id = pettl.element_type_id
1336: AND pettl.language = USERENV('LANG')
1337: AND iv.name = 'Pay Value'

Line 1755: ,pay_element_classifications pec

1751: ,pec.classification_name
1752: ,piv.uom
1753: ,piv.name input_value
1754: FROM hr_organization_information hoi
1755: ,pay_element_classifications pec
1756: ,pay_element_types_f pet
1757: ,pay_input_values_f piv
1758: WHERE hoi.organization_id = p_bus_grp_id
1759: AND hoi.org_information_context = 'KW_PAYSLIP_ELEMENTS'