APPS.PAY_ES_SS_CALCULATION dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 877: ,pay_element_entry_values_f peev1

873: SELECT Sum(decode(piv2.name, c_input_value_name, nvl(peev2.screen_entry_value,0), null)) adjusted_period
874: ,min(decode(piv2.name, 'Epigraph Code', nvl(peev2.screen_entry_value,'x'), null)) epigraph_code
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

Line 878: ,pay_element_entry_values_f peev2

874: ,min(decode(piv2.name, 'Epigraph Code', nvl(peev2.screen_entry_value,'x'), null)) epigraph_code
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

Line 1183: ,pay_element_entry_values_f peev

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
1187: AND pet.element_name = 'Social Security Details'

Line 1184: ,pay_element_entry_values_f peev2

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
1187: AND pet.element_name = 'Social Security Details'
1188: AND pet2.element_name = 'Multiple Employment Details'