APPS.PAY_ES_SS_CALCULATION dependencies on PAY_ELEMENT_ENTRIES_F

Line 876: FROM pay_element_entries_f peef1

872: ,c_period_end_date DATE) IS
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

Line 1177: FROM pay_element_entries_f pee

1173: ,min(decode(piv.name, 'SS Epigraph 126', nvl(peev.screen_entry_value,'x'), null)) epigraph_126
1174: ,min(decode(piv.name, 'SS Epigraph 114', nvl(peev.screen_entry_value,'x'), null)) epigraph_114
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

Line 1178: ,pay_element_entries_f pee2

1174: ,min(decode(piv.name, 'SS Epigraph 114', nvl(peev.screen_entry_value,'x'), null)) epigraph_114
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