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

Line 544: from pay_run_results prr

540: and pee1.effective_start_date <= p_accrual_start_date - 1 -- Change (4)
541: and pee1.effective_end_date between p_turn_of_year_date
542: and p_accrual_start_date - 1
543: and not exists (select 1
544: from pay_run_results prr
545: where prr.source_id = pee1.element_entry_id
546: and prr.element_type_id + 0 = pel1.element_type_id -- Change (5)
547: and prr.status in ('P', 'PA')
548: )

Line 550: from pay_run_results prr,

546: and prr.element_type_id + 0 = pel1.element_type_id -- Change (5)
547: and prr.status in ('P', 'PA')
548: )
549: and not exists (select 1
550: from pay_run_results prr,
551: pay_run_result_values rrv
552: where prr.run_result_id = rrv.run_result_id
553: and prr.source_id = pee2.element_entry_id
554: and prr.element_type_id + 0 = pap.tagging_element_type_id -- Change (6)

Line 581: from pay_run_results prr

577: and pee1.effective_start_date <= p_accrual_start_date
578: and pee1.effective_end_date between p_turn_of_year_date
579: and p_accrual_start_date
580: and not exists (select 1
581: from pay_run_results prr
582: where prr.source_id = pee1.element_entry_id
583: and prr.element_type_id + 0 = pee1.element_type_id -- fix new
584: and prr.status in ('P', 'PA')
585: )

Line 587: from pay_run_results prr,

583: and prr.element_type_id + 0 = pee1.element_type_id -- fix new
584: and prr.status in ('P', 'PA')
585: )
586: and not exists (select 1
587: from pay_run_results prr,
588: pay_run_result_values rrv
589: where prr.run_result_id = rrv.run_result_id
590: and prr.source_id = pee2.element_entry_id
591: and prr.element_type_id + 0 = pap.tagging_element_type_id

Line 605: from pay_run_results prr

601: and pee.assignment_id = p_assignment_id
602: and pap.accrual_plan_element_type_id = pel.element_type_id
603: and pel.element_link_id = pee.element_link_id
604: and exists (select 1
605: from pay_run_results prr
606: where prr.source_id = pee.element_entry_id
607: and prr.element_type_id + 0 = pel.element_type_id -- Change (7)
608: and prr.status in ('P', 'PA')
609: );

Line 699: from pay_run_results prr

695: and pee2.assignment_id = p_assignment_id
696: and pee1.effective_end_date < p_effective_date
697: and pee2.element_entry_id = p_entry_id
698: and not exists (select 1
699: from pay_run_results prr
700: where prr.source_id = pee1.element_entry_id
701: and prr.element_type_id + 0 = pel1.element_type_id -- Change (3)
702: and prr.status in ('P', 'PA')
703: )

Line 705: from pay_run_results prr,

701: and prr.element_type_id + 0 = pel1.element_type_id -- Change (3)
702: and prr.status in ('P', 'PA')
703: )
704: and not exists (select 1
705: from pay_run_results prr,
706: pay_run_result_values rrv
707: where prr.run_result_id = rrv.run_result_id
708: and prr.source_id = pee2.element_entry_id
709: and prr.element_type_id + 0 = pap.tagging_element_type_id -- Change (4)

Line 735: from pay_run_results prr

731: and pee2.assignment_id = p_assignment_id
732: and pee1.effective_end_date < p_effective_date
733: and pee2.element_entry_id = p_entry_id
734: and not exists (select 1
735: from pay_run_results prr
736: where prr.source_id = pee1.element_entry_id
737: and prr.element_type_id + 0 = pee1.element_type_id
738: and prr.status in ('P', 'PA')
739: )

Line 741: from pay_run_results prr,

737: and prr.element_type_id + 0 = pee1.element_type_id
738: and prr.status in ('P', 'PA')
739: )
740: and not exists (select 1
741: from pay_run_results prr,
742: pay_run_result_values rrv
743: where prr.run_result_id = rrv.run_result_id
744: and prr.source_id = pee2.element_entry_id
745: and prr.element_type_id + 0 = pap.tagging_element_type_id