DBA Data[Home] [Help]

APPS.PAY_DK_PAYMENT_PROCESS_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 248: , pay_element_entries_f pee

244: , pay_input_values_f piv2
245: , pay_input_values_f piv4
246: , pay_assignment_actions paa
247: , pay_payroll_actions ppa
248: , pay_element_entries_f pee
249: WHERE ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
250: AND prr1.ELEMENT_TYPE_ID = pet1.ELEMENT_TYPE_ID
251: AND prrv1.RUN_RESULT_ID = prr1.RUN_RESULT_ID
252: AND prrv3.RUN_RESULT_ID = prr1.RUN_RESULT_ID

Line 297: , pay_element_entries_f pee1

293: CURSOR get_is_record_01_details_local IS
294: SELECT '1'
295: FROM pay_payroll_actions ppa
296: , pay_assignment_actions paa
297: , pay_element_entries_f pee1
298: , pay_element_types_f pet
299: , pay_element_entries_f pee2
300: , hr_organization_units hou /*bug fix 4551283*/
301: /* Added for Pension changes */

Line 299: , pay_element_entries_f pee2

295: FROM pay_payroll_actions ppa
296: , pay_assignment_actions paa
297: , pay_element_entries_f pee1
298: , pay_element_types_f pet
299: , pay_element_entries_f pee2
300: , hr_organization_units hou /*bug fix 4551283*/
301: /* Added for Pension changes */
302: , pay_input_values_f pivf
303: , pay_element_entry_values_f peev1

Line 341: , pay_element_entries_f pee1

337: CURSOR get_is_record_02_details_local IS
338: SELECT '1'
339: FROM pay_payroll_actions ppa
340: , pay_assignment_actions paa
341: , pay_element_entries_f pee1
342: , pay_element_types_f pet
343: , pay_element_entries_f pee2
344: /* Added for Pension changes */
345: , pay_input_values_f pivf

Line 343: , pay_element_entries_f pee2

339: FROM pay_payroll_actions ppa
340: , pay_assignment_actions paa
341: , pay_element_entries_f pee1
342: , pay_element_types_f pet
343: , pay_element_entries_f pee2
344: /* Added for Pension changes */
345: , pay_input_values_f pivf
346: , pay_element_entry_values_f peev1
347: , pay_element_entry_values_f peev2

Line 380: , pay_element_entries_f pee1

376: CURSOR get_is_record_03_details_local IS
377: SELECT '1'
378: FROM pay_payroll_actions ppa
379: , pay_assignment_actions paa
380: , pay_element_entries_f pee1
381: , pay_element_types_f pet
382: , pay_element_entries_f pee2
383: /* Added for Pension changes */
384: , pay_input_values_f pivf

Line 382: , pay_element_entries_f pee2

378: FROM pay_payroll_actions ppa
379: , pay_assignment_actions paa
380: , pay_element_entries_f pee1
381: , pay_element_types_f pet
382: , pay_element_entries_f pee2
383: /* Added for Pension changes */
384: , pay_input_values_f pivf
385: , pay_element_entry_values_f peev1
386: , pay_element_entry_values_f peev2