APPS.PAY_IN_24Q_ARCHIVE dependencies on PER_ALL_ASSIGNMENTS_F

Line 949: FROM per_all_assignments_f paf

945:
946: CURSOR csr_payroll_id(p_assignment_id NUMBER,p_date DATE)
947: IS
948: SELECT paf.payroll_id
949: FROM per_all_assignments_f paf
950: WHERE paf.assignment_id =p_assignment_id
951: AND p_date BETWEEN paf.effective_start_date AND paf.effective_end_date;
952:
953: l_person_id per_all_people_f.person_id%TYPE;

Line 2416: ,per_all_assignments_f paf

2412: SELECT paa.assignment_id
2413: ,paa.payroll_action_id
2414: ,paf.person_id
2415: FROM pay_assignment_actions paa
2416: ,per_all_assignments_f paf
2417: WHERE paa.assignment_action_id = p_assignment_action_id
2418: AND paa.assignment_id = paf.assignment_id
2419: AND ROWNUM =1;
2420:

Line 2424: FROM per_all_assignments_f paf

2420:
2421: CURSOR c_get_distinct_gre(p_assignment_id NUMBER)
2422: IS
2423: SELECT DISTINCT(hscl.segment1) gre
2424: FROM per_all_assignments_f paf
2425: ,hr_soft_coding_keyflex hscl
2426: WHERE hscl.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
2427: AND paf.assignment_id =paf.assignment_id
2428: AND paf.assignment_id = p_assignment_id

Line 2455: FROM per_all_assignments_f paf

2451:
2452: CURSOR csr_payroll_id(p_assignment_id NUMBER,p_date DATE)
2453: IS
2454: SELECT paf.payroll_id
2455: FROM per_all_assignments_f paf
2456: WHERE paf.assignment_id =p_assignment_id
2457: AND p_date BETWEEN paf.effective_start_date AND paf.effective_end_date;
2458:
2459: CURSOR get_eoy_archival_details(p_start_date DATE

Line 2517: FROM per_all_assignments_f asg

2513:
2514: CURSOR c_termination_check(p_assignment_id NUMBER)
2515: IS
2516: SELECT NVL(pos.actual_termination_date,(fnd_date.string_to_date('31-12-4712','DD-MM-YYYY')))
2517: FROM per_all_assignments_f asg
2518: ,per_periods_of_service pos
2519: WHERE asg.person_id = pos.person_id
2520: AND asg.assignment_id = p_assignment_id
2521: AND asg.business_group_id = pos.business_group_id