APPS.PAY_KW_ARCHIVE dependencies on PAY_ELEMENT_TYPES_F

Line 210: ,pay_element_types_f pet

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'
214: AND hoi.org_information1 = pet.element_type_id

Line 1304: FROM pay_element_types_f et

1300: SELECT nvl(pettl.reporting_name,pettl.element_name) rep_name
1301: ,et.element_type_id element_type_id
1302: ,iv.input_value_id input_value_id
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

Line 1305: , pay_element_types_f_tl pettl

1301: ,et.element_type_id element_type_id
1302: ,iv.input_value_id input_value_id
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

Line 1330: FROM pay_element_types_f et

1326: SELECT nvl(pettl.reporting_name,pettl.element_name) rep_name
1327: ,et.element_type_id element_type_id
1328: ,iv.input_value_id input_value_id
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

Line 1331: , pay_element_types_f_tl pettl

1327: ,et.element_type_id element_type_id
1328: ,iv.input_value_id input_value_id
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

Line 1756: ,pay_element_types_f pet

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'
1760: AND hoi.org_information1 = pet.element_type_id