APPS.PAY_IE_PAYFILE_SEPA dependencies on PER_ALL_ASSIGNMENTS_F

Line 93: per_all_assignments_f asg,

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,
97: pay_org_payment_methods_f OPM,

Line 400: FROM per_all_assignments_f paf

396: ELSE
397:
398: SELECT person_id
399: INTO l_payee_id
400: FROM per_all_assignments_f paf
401: WHERE paf.assignment_id = p_assignment_id
402: AND p_date_earned BETWEEN paf.effective_start_date AND paf.effective_end_date;
403:
404: l_payee_type := 'P';

Line 462: ,per_all_assignments_f paaf

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
466: AND ppp.pre_payment_id = pas.pre_payment_id

Line 488: FROM per_all_assignments_f paf

484: SELECT SUM(employer_sum) er_sum,
485: SUM(record_count) er_count
486: FROM (SELECT SUM(ppp.value*100) employer_sum,
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