[Home] [Help]
184: ,piv.uom
185: --,code.org_information2 element_code
186: FROM hr_organization_information hoi
187: ,hr_organization_information code
188: ,pay_element_classifications pec
189: ,pay_element_types_f pet
190: ,pay_input_values_f piv
191: WHERE hoi.organization_id = p_bus_grp_id
192: AND hoi.org_information_context = 'Business Group:Payslip Info'
1139: ,iv.uom uom
1140: FROM pay_element_types_f et
1141: , pay_element_types_f_tl pettl
1142: , pay_input_values_f iv
1143: , pay_element_classifications classification
1144: ,hr_organization_information code
1145: WHERE et.element_type_id = iv.element_type_id
1146: AND et.element_type_id = pettl.element_type_id
1147: AND pettl.language = USERENV('LANG')
1168: ,iv.uom uom
1169: FROM pay_element_types_f et
1170: , pay_element_types_f_tl pettl
1171: , pay_input_values_f iv
1172: , pay_element_classifications classification
1173: WHERE et.element_type_id = iv.element_type_id
1174: AND et.element_type_id = pettl.element_type_id
1175: AND pettl.language = USERENV('LANG')
1176: AND iv.name = 'Pay Value'
1200: ,iv.uom uom
1201: FROM pay_element_types_f et
1202: , pay_element_types_f_tl pettl
1203: , pay_input_values_f iv
1204: , pay_element_classifications classification
1205: ,hr_organization_information code
1206: WHERE et.element_type_id = iv.element_type_id
1207: AND et.element_type_id = pettl.element_type_id
1208: AND pettl.language = USERENV('LANG')
1227: ,iv.uom uom
1228: FROM pay_element_types_f et
1229: , pay_element_types_f_tl pettl
1230: , pay_input_values_f iv
1231: , pay_element_classifications classification
1232: WHERE et.element_type_id = iv.element_type_id
1233: AND et.element_type_id = pettl.element_type_id
1234: AND pettl.language = USERENV('LANG')
1235: AND iv.name = 'Pay Value'
1596: ,hoi.org_information7 element_narrative
1597: ,pec.classification_name
1598: ,piv.uom
1599: FROM hr_organization_information hoi
1600: ,pay_element_classifications pec
1601: ,pay_element_types_f pet
1602: ,pay_input_values_f piv
1603: WHERE hoi.organization_id = p_bus_grp_id
1604: AND hoi.org_information_context = 'Business Group:Payslip Info'
1614: ,pec.classification_name
1615: ,piv.uom
1616: ,code.org_information2 element_code
1617: FROM hr_organization_information hoi
1618: ,pay_element_classifications pec
1619: ,pay_element_types_f pet
1620: ,pay_input_values_f piv
1621: ,hr_organization_information code
1622: WHERE hoi.organization_id = p_bus_grp_id
2769: ,iv.uom uom
2770: FROM pay_element_types_f et
2771: , pay_element_types_f_tl pettl
2772: , pay_input_values_f iv
2773: , pay_element_classifications classification
2774: WHERE et.element_type_id = iv.element_type_id
2775: AND et.element_type_id = pettl.element_type_id
2776: AND pettl.language = USERENV('LANG')
2777: AND iv.name = 'Pay Value'
2797: ,code.org_information2 element_code
2798: FROM pay_element_types_f et
2799: , pay_element_types_f_tl pettl
2800: , pay_input_values_f iv
2801: , pay_element_classifications classification
2802: ,hr_organization_information code
2803: WHERE et.element_type_id = iv.element_type_id
2804: AND et.element_type_id = pettl.element_type_id
2805: AND pettl.language = USERENV('LANG')
2836: ,iv.uom uom
2837: FROM pay_element_types_f et
2838: , pay_element_types_f_tl pettl
2839: , pay_input_values_f iv
2840: , pay_element_classifications classification
2841: WHERE et.element_type_id = iv.element_type_id
2842: AND et.element_type_id = pettl.element_type_id
2843: AND pettl.language = USERENV('LANG')
2844: AND iv.name = 'Pay Value'
2860: ,code.org_information2 element_code
2861: FROM pay_element_types_f et
2862: , pay_element_types_f_tl pettl
2863: , pay_input_values_f iv
2864: , pay_element_classifications classification
2865: ,hr_organization_information code
2866: WHERE et.element_type_id = iv.element_type_id
2867: AND et.element_type_id = pettl.element_type_id
2868: AND pettl.language = USERENV('LANG')