DBA Data[Home] [Help]

APPS.PAY_ES_SS_CALCULATION dependencies on PAY_ELEMENT_TYPES_F

Line 881: ,pay_element_types_f pet

877: ,pay_element_entry_values_f peev1
878: ,pay_element_entry_values_f peev2
879: ,pay_input_values_f piv1
880: ,pay_input_values_f piv2
881: ,pay_element_types_f pet
882: WHERE pet.element_name = c_element_name
883: AND piv1.element_type_id = pet.element_type_id
884: AND piv2.element_type_id = pet.element_type_id
885: AND pet.legislation_code = 'ES'

Line 1179: ,pay_element_types_f pet

1175: ,min(decode(piv.name, 'SS Epigraph Code', nvl(peev.screen_entry_value,'x'), null)) epigraph_code
1176: ,min(decode(piv2.name, 'Work Center CAC', nvl(peev2.screen_entry_value,0), null)) work_center_cac
1177: FROM pay_element_entries_f pee
1178: ,pay_element_entries_f pee2
1179: ,pay_element_types_f pet
1180: ,pay_element_types_f pet2
1181: ,pay_input_values_f piv
1182: ,pay_input_values_f piv2
1183: ,pay_element_entry_values_f peev

Line 1180: ,pay_element_types_f pet2

1176: ,min(decode(piv2.name, 'Work Center CAC', nvl(peev2.screen_entry_value,0), null)) work_center_cac
1177: FROM pay_element_entries_f pee
1178: ,pay_element_entries_f pee2
1179: ,pay_element_types_f pet
1180: ,pay_element_types_f pet2
1181: ,pay_input_values_f piv
1182: ,pay_input_values_f piv2
1183: ,pay_element_entry_values_f peev
1184: ,pay_element_entry_values_f peev2