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_CN_DEDUCTIONS dependencies on PAY_PAYROLL_ACTIONS

Line 4522: , pay_payroll_actions ppa

4518: /* cursor to fetch the latest asg action id in the target year from Jan to Dec */
4519: CURSOR get_prev_yr_asg_act_id(c_assignment_id IN NUMBER,c_date IN DATE) IS
4520: select /*+ORDERED*/ to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16))
4521: from pay_assignment_actions paa
4522: , pay_payroll_actions ppa
4523: where paa.assignment_id = c_assignment_id
4524: and ppa.payroll_action_id = paa.payroll_action_id
4525: and ppa.effective_date <= trunc(c_date,'Y') - 1
4526: and ppa.effective_date >= trunc(add_months(c_date,-12),'Y')

Line 4536: , pay_payroll_actions ppa

4532: /* cursor to fetch the latest asg action id in the target month */
4533: CURSOR get_prev_mth_asg_act_id(c_assignment_id IN NUMBER,c_date IN DATE) IS
4534: select /*+ORDERED*/ to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16))
4535: from pay_assignment_actions paa
4536: , pay_payroll_actions ppa
4537: where paa.assignment_id = c_assignment_id
4538: and ppa.payroll_action_id = paa.payroll_action_id
4539: and ppa.effective_date <= c_date - 1
4540: and ppa.effective_date >= add_months(c_date,-1)