DBA Data[Home] [Help]

APPS.PER_UTILITY_FUNCTIONS dependencies on PAY_RUN_RESULT_VALUES

Line 551: pay_run_result_values rrv

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)
555: and rrv.result_value = pee1.element_entry_id

Line 588: pay_run_result_values rrv

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
592: and rrv.result_value = pee1.element_entry_id

Line 706: pay_run_result_values rrv

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)
710: and rrv.result_value = pee1.element_entry_id

Line 742: pay_run_result_values rrv

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
746: and rrv.result_value = pee1.element_entry_id