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

Line 2392: from per_time_periods ptp,

2388: --
2389: cursor csr_get_time_period is
2390: select ptp2.start_date,
2391: ptp2.end_date
2392: from per_time_periods ptp,
2393: pay_payroll_actions ppa,
2394: per_time_periods ptp2
2395: where ppa.date_earned BETWEEN ptp.START_DATE and ptp.END_DATE
2396: and ppa.payroll_action_id = p_payroll_action_id

Line 2394: per_time_periods ptp2

2390: select ptp2.start_date,
2391: ptp2.end_date
2392: from per_time_periods ptp,
2393: pay_payroll_actions ppa,
2394: per_time_periods ptp2
2395: where ppa.date_earned BETWEEN ptp.START_DATE and ptp.END_DATE
2396: and ppa.payroll_action_id = p_payroll_action_id
2397: and ptp.payroll_id = ppa.payroll_id
2398: and ptp2.end_date = ptp.start_date - 1