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.PQP_USTIAA_PKG dependencies on PAY_RUN_RESULTS

Line 355: FROM pay_run_results rr,

351: AND asg.person_id BETWEEN stperson
352: AND endperson
353: AND EXISTS (
354: select NULL
355: FROM pay_run_results rr,
356: pay_element_types_f e,
357: pay_element_type_extra_info ei
358: WHERE rr.assignment_action_id = act_run.assignment_action_id
359: AND rr.element_type_id = e.element_type_id

Line 603: FROM pay_run_results rr,

599: p_date DATE) RETURN boolean IS
600:
601: Cursor csr_chk_dup_bal_types is
602: SELECT count(*)
603: FROM pay_run_results rr,
604: pay_element_types_f e,
605: pay_element_type_extra_info ei
606: WHERE rr.assignment_action_id = p_asgact_id
607: AND rr.element_type_id = e.element_type_id

Line 613: FROM pay_run_results rr1,

609: AND ei.information_type = 'US_TIAA_CREF_CONT_TYPES'
610: AND p_date BETWEEN e.effective_start_date AND e.effective_end_date
611: AND rr.entry_type not in ('A','R')
612: and rr.rowid > (SELECT min(rr1.rowid)
613: FROM pay_run_results rr1,
614: pay_element_types_f e1,
615: pay_element_type_extra_info ei1
616: WHERE rr1.assignment_action_id = rr.assignment_action_id
617: AND rr1.element_type_id = e1.element_type_id

Line 850: FROM pay_run_results rr,

846: ei.eei_information2 cont_sub_plan,
847: ei.eei_information3 plan_no,
848: e.element_information10 bal_type_id,
849: e.element_name
850: FROM pay_run_results rr,
851: pay_element_types_f e,
852: pay_element_type_extra_info ei
853: WHERE rr.assignment_action_id = p_asgact_id
854: AND rr.element_type_id = e.element_type_id