DBA Data[Home] [Help]

APPS.PAY_IE_PRSI_API dependencies on PER_TIME_PERIODS

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 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: --