[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'
1137: ,iv.uom uom
1138: FROM pay_element_types_f et
1139: , pay_element_types_f_tl pettl
1140: , pay_input_values_f iv
1141: , pay_element_classifications classification
1142: ,hr_organization_information code
1143: WHERE et.element_type_id = iv.element_type_id
1144: AND et.element_type_id = pettl.element_type_id
1145: AND pettl.language = USERENV('LANG')
1166: ,iv.uom uom
1167: FROM pay_element_types_f et
1168: , pay_element_types_f_tl pettl
1169: , pay_input_values_f iv
1170: , pay_element_classifications classification
1171: WHERE et.element_type_id = iv.element_type_id
1172: AND et.element_type_id = pettl.element_type_id
1173: AND pettl.language = USERENV('LANG')
1174: AND iv.name = 'Pay Value'
1198: ,iv.uom uom
1199: FROM pay_element_types_f et
1200: , pay_element_types_f_tl pettl
1201: , pay_input_values_f iv
1202: , pay_element_classifications classification
1203: ,hr_organization_information code
1204: WHERE et.element_type_id = iv.element_type_id
1205: AND et.element_type_id = pettl.element_type_id
1206: AND pettl.language = USERENV('LANG')
1225: ,iv.uom uom
1226: FROM pay_element_types_f et
1227: , pay_element_types_f_tl pettl
1228: , pay_input_values_f iv
1229: , pay_element_classifications classification
1230: WHERE et.element_type_id = iv.element_type_id
1231: AND et.element_type_id = pettl.element_type_id
1232: AND pettl.language = USERENV('LANG')
1233: AND iv.name = 'Pay Value'
1594: ,hoi.org_information7 element_narrative
1595: ,pec.classification_name
1596: ,piv.uom
1597: FROM hr_organization_information hoi
1598: ,pay_element_classifications pec
1599: ,pay_element_types_f pet
1600: ,pay_input_values_f piv
1601: WHERE hoi.organization_id = p_bus_grp_id
1602: AND hoi.org_information_context = 'Business Group:Payslip Info'
1612: ,pec.classification_name
1613: ,piv.uom
1614: ,code.org_information2 element_code
1615: FROM hr_organization_information hoi
1616: ,pay_element_classifications pec
1617: ,pay_element_types_f pet
1618: ,pay_input_values_f piv
1619: ,hr_organization_information code
1620: WHERE hoi.organization_id = p_bus_grp_id
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'
2785: ,code.org_information2 element_code
2786: FROM pay_element_types_f et
2787: , pay_element_types_f_tl pettl
2788: , pay_input_values_f iv
2789: , pay_element_classifications classification
2790: ,hr_organization_information code
2791: WHERE et.element_type_id = iv.element_type_id
2792: AND et.element_type_id = pettl.element_type_id
2793: AND pettl.language = USERENV('LANG')
2824: ,iv.uom uom
2825: FROM pay_element_types_f et
2826: , pay_element_types_f_tl pettl
2827: , pay_input_values_f iv
2828: , pay_element_classifications classification
2829: WHERE et.element_type_id = iv.element_type_id
2830: AND et.element_type_id = pettl.element_type_id
2831: AND pettl.language = USERENV('LANG')
2832: AND iv.name = 'Pay Value'
2848: ,code.org_information2 element_code
2849: FROM pay_element_types_f et
2850: , pay_element_types_f_tl pettl
2851: , pay_input_values_f iv
2852: , pay_element_classifications classification
2853: ,hr_organization_information code
2854: WHERE et.element_type_id = iv.element_type_id
2855: AND et.element_type_id = pettl.element_type_id
2856: AND pettl.language = USERENV('LANG')