APPS.PAY_NL_PAYFILE_SEPA dependencies on PER_ALL_ASSIGNMENTS_F

Line 387: FROM per_all_assignments_f paf

383: --
384: l_payee_name := substr(l_outputs(1).value,1,35);
385:
386: SELECT person_id INTO l_payee_id
387: FROM per_all_assignments_f paf
388: WHERE paf.assignment_id = p_assignment_id
389: AND p_date_earned BETWEEN paf.effective_start_date
390: AND paf.effective_end_date;
391:

Line 405: FROM per_all_assignments_f paf

401: END IF;
402: END IF;
403:
404: SELECT person_id INTO l_payee_id
405: FROM per_all_assignments_f paf
406: WHERE paf.assignment_id = p_assignment_id
407: AND p_date_earned BETWEEN paf.effective_start_date
408: AND paf.effective_end_date;
409:

Line 590: ,per_all_assignments_f paaf

586: SELECT 1
587: FROM
588: pay_assignment_actions pas
589: ,pay_pre_payments ppp
590: ,per_all_assignments_f paaf
591: ,pay_all_payrolls_f ppf
592: WHERE pas.payroll_action_id = ppa.payroll_action_id
593: AND ppp.pre_payment_id = pas.pre_payment_id
594: AND ppp.value > 0

Line 614: FROM per_all_assignments_f paf

610: SELECT SUM(employer_sum) er_sum, SUM(record_count) er_count
611: FROM
612: (SELECT
613: SUM(ppp.value*100) employer_sum, 1 record_count
614: FROM per_all_assignments_f paf
615: ,per_all_people_f pef
616: ,pay_all_payrolls_f ppf
617: ,pay_pre_payments ppp
618: ,pay_assignment_actions paa