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

Line 280: from per_time_periods

276: cursor csr_get_payroll_period is
277: select start_date
278: , end_date
279: , period_num
280: from per_time_periods
281: where payroll_id = p_payroll_id
282: and p_date between start_date and end_date;
283:
284: l_procedure VARCHAR2(250);

Line 4612: per_time_periods ptp,

4608: CURSOR c_recent_run_action IS
4609: SELECT to_number(substr(max(lpad(prev_asg.action_sequence,15,'0')||prev_asg.assignment_action_id),16))
4610: FROM pay_assignment_actions prev_asg,
4611: pay_payroll_actions prev_pay,
4612: per_time_periods ptp,
4613: pay_assignment_actions cur_asg,
4614: pay_payroll_actions cur_pay
4615: WHERE prev_asg.assignment_id = p_assignment_id
4616: AND prev_asg.payroll_action_id = prev_pay.payroll_action_id

Line 4710: per_time_periods ptp,

4706: RETURN VARCHAR2
4707: IS
4708: CURSOR csr_regular_run IS
4709: SELECT 'Y' FROM
4710: per_time_periods ptp,
4711: pay_payroll_actions pact,
4712: pay_assignment_actions assact,
4713: pay_payroll_actions bact,
4714: pay_assignment_actions bal_assact,