APPS.PAY_IE_PRSI_API dependencies on PER_ALL_ASSIGNMENTS_F

Line 66: FROM per_time_periods ptp, per_all_assignments_f paa

62: -- Declare cursors and local variables
63: --
64: CURSOR period_csr IS
65: SELECT ptp.start_date, ptp.end_Date
66: FROM per_time_periods ptp, per_all_assignments_f paa
67: WHERE paa.assignment_id = p_assignment_id
68: AND paa.payroll_id = ptp.payroll_id
69: AND p_effective_date BETWEEN ptp.start_date AND ptp.end_date;
70: --

Line 90: FROM per_all_assignments_f

86: l_business_group_id number;
87: --
88: CURSOR business_group_csr IS
89: SELECT business_group_id
90: FROM per_all_assignments_f
91: WHERE assignment_id = p_assignment_id
92: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
93: --
94: --

Line 355: FROM per_all_assignments_f

351: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
352: --
353: CURSOR business_group_csr IS
354: SELECT business_group_id
355: FROM per_all_assignments_f
356: WHERE assignment_id = l_assignment_id
357: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
358: --
359: CURSOR period_csr IS

Line 361: FROM per_time_periods ptp, per_all_assignments_f paa

357: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
358: --
359: CURSOR period_csr IS
360: SELECT ptp.start_date, ptp.end_Date
361: FROM per_time_periods ptp, per_all_assignments_f paa
362: WHERE paa.assignment_id = l_assignment_id
363: AND paa.payroll_id = ptp.payroll_id
364: AND p_effective_date BETWEEN ptp.start_date AND ptp.end_date;
365: --

Line 625: FROM per_all_assignments_f

621: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
622: --
623: CURSOR business_group_csr IS
624: SELECT business_group_id
625: FROM per_all_assignments_f
626: WHERE assignment_id = l_assignment_id
627: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
628: --
629: --