APPS.PAY_NZ_EXC dependencies on PER_TIME_PERIODS

Line 173: from per_time_periods ptp,

169: /* Get the date next to the end date of the given period,
170: having the payroll action id */
171: cursor csr_end_date is
172: select PTP.end_date
173: from per_time_periods ptp,
174: pay_payroll_actions pact
175: where pact.payroll_action_id = p_payroll_action_id
176: and pact.payroll_id = ptp.payroll_id
177: and p_given_date between ptp.start_date and ptp.end_date;

Line 385: FROM per_time_periods ptp

381: IS
382: CURSOR csr_get_start_date
383: IS
384: SELECT ptp.start_date - 28
385: FROM per_time_periods ptp
386: WHERE ptp.payroll_id = p_payroll_id
387: AND p_effective_date between ptp.start_date
388: and ptp.end_date;
389: BEGIN