eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_NZ_EXC dependencies on PER_TIME_PERIODS

Line 175: from per_time_periods ptp,

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

Line 387: FROM per_time_periods ptp

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

Line 539: FROM per_time_periods ptp

535: IS
536: CURSOR csr_get_start_date
537: IS
538: SELECT ptp.start_date - 364
539: FROM per_time_periods ptp
540: WHERE ptp.payroll_id = p_payroll_id
541: AND p_effective_date between ptp.start_date
542: and ptp.end_date;
543: BEGIN