DBA Data[Home] [Help]

APPS.PER_PYP_BUS dependencies on PER_PERFORMANCE_REVIEWS

Line 2633: -- Cursor to check existence of performance_review_id in per_performance_reviews

2629: l_exists varchar2(1);
2630: l_api_updating boolean;
2631: --
2632: --
2633: -- Cursor to check existence of performance_review_id in per_performance_reviews
2634: --
2635: --
2636: cursor csr_chk_performance_review_id is
2637: select null

Line 2638: from per_performance_reviews prv

2634: --
2635: --
2636: cursor csr_chk_performance_review_id is
2637: select null
2638: from per_performance_reviews prv
2639: , per_all_assignments_f asg
2640: where asg.assignment_id = p_assignment_id
2641: and asg.person_id=prv.person_id
2642: and prv.performance_review_id = p_performance_review_id;