APPS.PAY_IN_24Q_ARCHIVE dependencies on PER_ALL_ASSIGNMENTS_F

Line 1030: FROM per_all_assignments_f paf

1026:
1027: CURSOR csr_payroll_id(p_assignment_id NUMBER,p_date DATE)
1028: IS
1029: SELECT paf.payroll_id
1030: FROM per_all_assignments_f paf
1031: WHERE paf.assignment_id =p_assignment_id
1032: AND p_date BETWEEN paf.effective_start_date AND paf.effective_end_date;
1033:
1034: l_person_id per_all_people_f.person_id%TYPE;

Line 2522: ,per_all_assignments_f paf

2518: SELECT paa.assignment_id
2519: ,paa.payroll_action_id
2520: ,paf.person_id
2521: FROM pay_assignment_actions paa
2522: ,per_all_assignments_f paf
2523: WHERE paa.assignment_action_id = p_assignment_action_id
2524: AND paa.assignment_id = paf.assignment_id
2525: AND ROWNUM =1;
2526:

Line 2530: FROM per_all_assignments_f paf

2526:
2527: CURSOR c_get_distinct_gre(p_assignment_id NUMBER)
2528: IS
2529: SELECT DISTINCT(hscl.segment1) gre
2530: FROM per_all_assignments_f paf
2531: ,hr_soft_coding_keyflex hscl
2532: WHERE hscl.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
2533: AND paf.assignment_id =paf.assignment_id
2534: AND paf.assignment_id = p_assignment_id

Line 2561: FROM per_all_assignments_f paf

2557:
2558: CURSOR csr_payroll_id(p_assignment_id NUMBER,p_date DATE)
2559: IS
2560: SELECT paf.payroll_id
2561: FROM per_all_assignments_f paf
2562: WHERE paf.assignment_id =p_assignment_id
2563: AND p_date BETWEEN paf.effective_start_date AND paf.effective_end_date;
2564:
2565: CURSOR get_eoy_archival_details(p_start_date DATE

Line 2623: FROM per_all_assignments_f asg

2619:
2620: CURSOR c_termination_check(p_assignment_id NUMBER)
2621: IS
2622: SELECT NVL(pos.actual_termination_date,(fnd_date.string_to_date('31-12-4712','DD-MM-YYYY')))
2623: FROM per_all_assignments_f asg
2624: ,per_periods_of_service pos
2625: WHERE asg.person_id = pos.person_id
2626: AND asg.assignment_id = p_assignment_id
2627: AND asg.business_group_id = pos.business_group_id