199: ,pec.classification_name
200: ,piv.uom
201: FROM hr_organization_information hoi
202: ,pay_element_classifications pec
203: ,pay_element_types_f pet
204: ,pay_input_values_f piv
205: WHERE hoi.organization_id = p_bus_grp_id
206: AND hoi.org_information_context = 'SA_PAYSLIP_ELEMENTS'
207: AND hoi.org_information1 = pet.element_type_id
1331: SELECT nvl(pettl.reporting_name,pettl.element_name) rep_name
1332: ,et.element_type_id element_type_id
1333: ,iv.input_value_id input_value_id
1334: ,iv.uom uom
1335: FROM pay_element_types_f et
1336: , pay_element_types_f_tl pettl
1337: , pay_input_values_f iv
1338: , pay_element_classifications classification
1339: WHERE et.element_type_id = iv.element_type_id
1332: ,et.element_type_id element_type_id
1333: ,iv.input_value_id input_value_id
1334: ,iv.uom uom
1335: FROM pay_element_types_f et
1336: , pay_element_types_f_tl pettl
1337: , pay_input_values_f iv
1338: , pay_element_classifications classification
1339: WHERE et.element_type_id = iv.element_type_id
1340: AND et.element_type_id = pettl.element_type_id
1358: SELECT nvl(pettl.reporting_name,pettl.element_name) rep_name
1359: ,et.element_type_id element_type_id
1360: ,iv.input_value_id input_value_id
1361: ,iv.uom uom
1362: FROM pay_element_types_f et
1363: , pay_element_types_f_tl pettl
1364: , pay_input_values_f iv
1365: , pay_element_classifications classification
1366: WHERE et.element_type_id = iv.element_type_id
1359: ,et.element_type_id element_type_id
1360: ,iv.input_value_id input_value_id
1361: ,iv.uom uom
1362: FROM pay_element_types_f et
1363: , pay_element_types_f_tl pettl
1364: , pay_input_values_f iv
1365: , pay_element_classifications classification
1366: WHERE et.element_type_id = iv.element_type_id
1367: AND et.element_type_id = pettl.element_type_id
1773: ,ppa.payroll_id
1774: ,pap.business_group_id
1775: ,pap.accrual_plan_id
1776: FROM pay_accrual_plans pap
1777: ,pay_element_types_f pet
1778: ,pay_element_links_f pel
1779: ,pay_element_entries_f pee
1780: ,pay_assignment_actions paa
1781: ,pay_payroll_actions ppa
1928: ,pec.classification_name
1929: ,piv.uom
1930: FROM hr_organization_information hoi
1931: ,pay_element_classifications pec
1932: ,pay_element_types_f pet
1933: ,pay_input_values_f piv
1934: WHERE hoi.organization_id = p_bus_grp_id
1935: AND hoi.org_information_context = 'SA_PAYSLIP_ELEMENTS'
1936: AND hoi.org_information1 = pet.element_type_id