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_RUN_RESULTS

Line 404: FROM pay_run_results prr,

400: AND pac.action_status = 'C'
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: )

Line 428: FROM pay_run_results prr

424: AND pac.assignment_id = p_assignment_id
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');

Line 572: FROM pay_run_results prr

568: AND pet1.effective_start_date <= p_session_date )
569: AND ee.assignment_id = p_assignment_id
570: AND EXISTS
571: (SELECT prr.element_type_id
572: FROM pay_run_results prr
573: WHERE prr.source_id = ee.element_entry_id
574: AND prr.source_type IN ( 'E' , 'I' )
575: AND prr.element_type_id + 0 = pet.element_type_id
576: )

Line 610: FROM pay_run_results prr

606: AND pet1.effective_start_date <= p_session_date )
607: AND ee.assignment_id = p_assignment_id
608: AND EXISTS
609: (SELECT prr.element_type_id
610: FROM pay_run_results prr
611: WHERE prr.source_id = ee.element_entry_id
612: AND prr.source_type IN ( 'E' , 'I' )
613: AND prr.element_type_id + 0 = pet.element_type_id
614: )

Line 631: ,pay_run_results prr

627: ,pet.element_type_id
628: ,pet.classification_id
629: ,pet.element_information10
630: FROM pay_element_types_f pet
631: ,pay_run_results prr
632: WHERE prr.assignment_action_id = p_assignment_action_id
633: AND pet.element_type_id = prr.element_type_id
634: AND pet.business_group_id = p_business_group_id
635: AND pet.classification_id = l_classification_id

Line 652: ,pay_run_results prr

648: ,pet.element_information10
649: ,pet.element_information11
650: ,pet.element_information13
651: FROM pay_element_types_f pet
652: ,pay_run_results prr
653: WHERE prr.assignment_action_id = p_assignment_action_id
654: AND pet.element_type_id = prr.element_type_id
655: AND pet.business_group_id = p_business_group_id
656: AND pet.classification_id = l_classification_id