APPS.PER_UTILITY_FUNCTIONS dependencies on PAY_RUN_RESULTS

Line 448: from pay_run_results prr

444: and pee1.effective_start_date <= p_accrual_start_date - 1 -- Change (4)
445: and pee1.effective_end_date between p_turn_of_year_date
446: and p_accrual_start_date - 1
447: and not exists (select 1
448: from pay_run_results prr
449: where prr.source_id = pee1.element_entry_id
450: and prr.element_type_id + 0 = pel1.element_type_id -- Change (5)
451: and prr.status in ('P', 'PA')
452: )

Line 454: from pay_run_results prr,

450: and prr.element_type_id + 0 = pel1.element_type_id -- Change (5)
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)

Line 485: from pay_run_results prr

481: and pee1.effective_start_date <= p_accrual_start_date
482: and pee1.effective_end_date between p_turn_of_year_date
483: and p_accrual_start_date
484: and not exists (select 1
485: from pay_run_results prr
486: where prr.source_id = pee1.element_entry_id
487: and prr.element_type_id + 0 = pee1.element_type_id -- fix new
488: and prr.status in ('P', 'PA')
489: )

Line 491: from pay_run_results prr,

487: and prr.element_type_id + 0 = pee1.element_type_id -- fix new
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

Line 509: from pay_run_results prr

505: and pee.assignment_id = p_assignment_id
506: and pap.accrual_plan_element_type_id = pel.element_type_id
507: and pel.element_link_id = pee.element_link_id
508: and exists (select 1
509: from pay_run_results prr
510: where prr.source_id = pee.element_entry_id
511: and prr.element_type_id + 0 = pel.element_type_id -- Change (7)
512: and prr.status in ('P', 'PA')
513: );

Line 603: from pay_run_results prr

599: and pee2.assignment_id = p_assignment_id
600: and pee1.effective_end_date < p_effective_date
601: and pee2.element_entry_id = p_entry_id
602: and not exists (select 1
603: from pay_run_results prr
604: where prr.source_id = pee1.element_entry_id
605: and prr.element_type_id + 0 = pel1.element_type_id -- Change (3)
606: and prr.status in ('P', 'PA')
607: )

Line 609: from pay_run_results prr,

605: and prr.element_type_id + 0 = pel1.element_type_id -- Change (3)
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)

Line 639: from pay_run_results prr

635: and pee2.assignment_id = p_assignment_id
636: and pee1.effective_end_date < p_effective_date
637: and pee2.element_entry_id = p_entry_id
638: and not exists (select 1
639: from pay_run_results prr
640: where prr.source_id = pee1.element_entry_id
641: and prr.element_type_id + 0 = pee1.element_type_id
642: and prr.status in ('P', 'PA')
643: )

Line 645: from pay_run_results prr,

641: and prr.element_type_id + 0 = pee1.element_type_id
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