[Home] [Help]
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,
97: pay_org_payment_methods_f OPM,
98: pay_payment_types PPT,
99: per_all_people_f pap
100: WHERE pa1.payroll_action_id = p_payroll_action_id
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
465: WHERE pas.payroll_action_id = ppa.payroll_action_id
487: 1 record_count
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