DBA Data[Home] [Help]

APPS.PAY_ES_SS_CALCULATION dependencies on PAY_INPUT_VALUES_F

Line 879: ,pay_input_values_f piv1

875: ,min(decode(piv2.name, 'Secondary CAC', nvl(peev2.screen_entry_value,'x'), null)) Secondary_CAC
876: FROM pay_element_entries_f peef1
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

Line 880: ,pay_input_values_f piv2

876: FROM pay_element_entries_f peef1
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

Line 1181: ,pay_input_values_f piv

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
1185: WHERE pee.assignment_id = c_assignment_id

Line 1182: ,pay_input_values_f piv2

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
1185: WHERE pee.assignment_id = c_assignment_id
1186: AND pee2.assignment_id = pee.assignment_id