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 158: from per_time_periods

154: , decode(to_char(end_date,'MM'),'04',1,'05',2,'06',3,
155: '07',4,'08',5,'09',6,
156: '10',7,'11',8,'12',9,
157: '01',10,'02',11,'03',12)
158: from per_time_periods
159: where payroll_id = p_payroll_id
160: and p_date between start_date and end_date;
161:
162: l_procedure VARCHAR2(250);

Line 3559: per_time_periods ptp,

3555: CURSOR c_recent_run_action IS
3556: SELECT to_number(substr(max(lpad(prev_asg.action_sequence,15,'0')||prev_asg.assignment_action_id),16))
3557: FROM pay_assignment_actions prev_asg,
3558: pay_payroll_actions prev_pay,
3559: per_time_periods ptp,
3560: pay_assignment_actions cur_asg,
3561: pay_payroll_actions cur_pay
3562: WHERE prev_asg.assignment_id = p_assignment_id
3563: AND prev_asg.payroll_action_id = prev_pay.payroll_action_id

Line 3657: per_time_periods ptp,

3653: RETURN VARCHAR2
3654: IS
3655: CURSOR csr_regular_run IS
3656: SELECT 'Y' FROM
3657: per_time_periods ptp,
3658: pay_payroll_actions pact,
3659: pay_assignment_actions assact,
3660: pay_payroll_actions bact,
3661: pay_assignment_actions bal_assact,