APPS.PAY_IE_PAYFILE_SEPA dependencies on PAY_ASSIGNMENT_ACTIONS

Line 92: FROM pay_assignment_actions act,

88: p_person_id NUMBER) IS
89: SELECT act.assignment_action_id,
90: act.assignment_id,
91: ppp.pre_payment_id
92: FROM pay_assignment_actions act,
93: per_all_assignments_f asg,
94: pay_payroll_actions pa2,
95: pay_payroll_actions pa1,
96: pay_pre_payments ppp,

Line 127: pay_assignment_actions act2,

123: AND hr_asg.assignment_id = asg.assignment_id
124: ))
125: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL
126: FROM pay_action_interlocks pai1,
127: pay_assignment_actions act2,
128: pay_payroll_actions appa
129: WHERE pai1.locked_action_id = act.assignment_action_id
130: AND act2.assignment_action_id = pai1.locking_action_id
131: AND act2.payroll_action_id = appa.payroll_action_id

Line 178: SELECT pay_assignment_actions_s.nextval

174: ,l_consolidation_set
175: ,l_assignment_set_id
176: ,l_person_id) LOOP
177:
178: SELECT pay_assignment_actions_s.nextval
179: INTO l_locking_action_id
180: FROM dual;
181:
182:

Line 460: FROM pay_assignment_actions pas

456: and pea.external_account_id = popmf.external_account_id and
457: --restricting employer who doesn't have any assignment to pay.
458: EXISTS
459: (SELECT 1
460: FROM pay_assignment_actions pas
461: ,pay_pre_payments ppp
462: ,per_all_assignments_f paaf
463: ,pay_all_payrolls_f ppf
464: ,hr_soft_coding_keyflex hsck1

Line 492: ,pay_assignment_actions paa

488: FROM per_all_assignments_f paf
489: ,per_all_people_f pef
490: ,pay_all_payrolls_f ppf
491: ,pay_pre_payments ppp
492: ,pay_assignment_actions paa
493: ,pay_payroll_actions ppa
494: ,pay_personal_payment_methods_f ppmf
495: ,pay_external_accounts pea
496: WHERE paa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')