DBA Data[Home] [Help]

APPS.PER_PYP_BUS dependencies on PER_PERFORMANCE_REVIEWS

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

2772: l_exists varchar2(1);
2773: l_api_updating boolean;
2774: --
2775: --
2776: -- Cursor to check existence of performance_review_id in per_performance_reviews
2777: --
2778: --
2779: cursor csr_chk_performance_review_id is
2780: select null

Line 2781: from per_performance_reviews prv

2777: --
2778: --
2779: cursor csr_chk_performance_review_id is
2780: select null
2781: from per_performance_reviews prv
2782: , per_all_assignments_f asg
2783: where asg.assignment_id = p_assignment_id
2784: and asg.person_id=prv.person_id
2785: and prv.performance_review_id = p_performance_review_id;