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_IP_EMPLOYEE_BALANCES dependencies on PAY_ASSIGNMENT_ACTIONS

Line 395: FROM pay_assignment_actions pac

391: ******************************************************************************/
392:
393: CURSOR c_action_type_tu IS
394: SELECT pay.action_type
395: FROM pay_assignment_actions pac
396: ,pay_payroll_actions pay
397: WHERE pay.payroll_action_id = pac.payroll_action_id
398: AND pay.action_type IN ('Q','R','I')
399: AND pac.assignment_id = p_assignment_id

Line 405: pay_assignment_actions pac1

401: AND pac.tax_unit_id = p_tax_unit_id
402: AND EXISTS
403: (SELECT 'x'
404: FROM pay_run_results prr,
405: pay_assignment_actions pac1
406: WHERE prr.assignment_action_id = pac1.assignment_action_id
407: AND pac1.assignment_id = pac.assignment_id
408: )
409: ORDER BY decode(pay.action_type,'Q','1','R','1','I','2','3');

Line 419: FROM pay_assignment_actions pac

415: ******************************************************************************/
416:
417: CURSOR c_action_type_bg IS
418: SELECT pay.action_type
419: FROM pay_assignment_actions pac
420: ,pay_payroll_actions pay
421: WHERE pay.payroll_action_id = pac.payroll_action_id
422: AND pay.business_group_id = p_business_group_id
423: AND pay.action_type IN ('Q','R','I')

Line 429: ,pay_assignment_actions pac1

425: AND pac.action_status = 'C'
426: AND EXISTS
427: (SELECT 'x'
428: FROM pay_run_results prr
429: ,pay_assignment_actions pac1
430: WHERE prr.assignment_action_id = pac1.assignment_action_id
431: AND pac1.assignment_id = pac.assignment_id)
432: ORDER BY decode(pay.action_type,'Q','1','R','1','I','2','3');
433: