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_NO_ABSENCE dependencies on PER_TIME_PERIODS

Line 220: FROM per_all_assignmeNts_f paaf, PER_TIME_PERIODS ptp

216:
217: /* Cursor to get the initial absence payroll start date */
218: CURSOR csr_intial_abs_pay_stdt (p_assignment_id in number, p_initial_abs_start_date in date) is
219: SELECT ptp.start_date
220: FROM per_all_assignmeNts_f paaf, PER_TIME_PERIODS ptp
221: WHERE paaf.assignment_id = p_assignment_id
222: AND ptp.payroll_id = paaf.payroll_id
223: AND p_initial_abs_start_date between ptp.start_date and ptp.end_date;
224:

Line 7584: FROM per_all_assignments_f paaf, per_time_periods ptp

7580:
7581: /* Cursor to get the payroll start date given absence*/
7582: CURSOR csr_intial_abs_pay_stdt (p_assignment_id number, p_initial_abs_start_date date) is
7583: SELECT ptp.start_date
7584: FROM per_all_assignments_f paaf, per_time_periods ptp
7585: WHERE paaf.assignment_id = p_assignment_id
7586: AND ptp.payroll_id = paaf.payroll_id
7587: AND p_initial_abs_start_date between ptp.start_date and ptp.end_date;
7588: