DBA Data[Home] [Help]

APPS.PER_UTILITY_FUNCTIONS dependencies on PAY_RUN_RESULT_VALUES

Line 455: pay_run_result_values rrv

451: and prr.status in ('P', 'PA')
452: )
453: and not exists (select 1
454: from pay_run_results prr,
455: pay_run_result_values rrv
456: where prr.run_result_id = rrv.run_result_id
457: and prr.source_id = pee2.element_entry_id
458: and prr.element_type_id + 0 = pap.tagging_element_type_id -- Change (6)
459: and rrv.result_value = pee1.element_entry_id

Line 492: pay_run_result_values rrv

488: and prr.status in ('P', 'PA')
489: )
490: and not exists (select 1
491: from pay_run_results prr,
492: pay_run_result_values rrv
493: where prr.run_result_id = rrv.run_result_id
494: and prr.source_id = pee2.element_entry_id
495: and prr.element_type_id + 0 = pap.tagging_element_type_id
496: and rrv.result_value = pee1.element_entry_id

Line 610: pay_run_result_values rrv

606: and prr.status in ('P', 'PA')
607: )
608: and not exists (select 1
609: from pay_run_results prr,
610: pay_run_result_values rrv
611: where prr.run_result_id = rrv.run_result_id
612: and prr.source_id = pee2.element_entry_id
613: and prr.element_type_id + 0 = pap.tagging_element_type_id -- Change (4)
614: and rrv.result_value = pee1.element_entry_id

Line 646: pay_run_result_values rrv

642: and prr.status in ('P', 'PA')
643: )
644: and not exists (select 1
645: from pay_run_results prr,
646: pay_run_result_values rrv
647: where prr.run_result_id = rrv.run_result_id
648: and prr.source_id = pee2.element_entry_id
649: and prr.element_type_id + 0 = pap.tagging_element_type_id
650: and rrv.result_value = pee1.element_entry_id