DBA Data[Home] [Help]

APPS.PER_PMS_BUS dependencies on PER_OBJECTIVES

Line 780: -- FROM per_objectives obj

776:
777: -- Bug 11823464
778: -- CURSOR csr_objs_outside_scorecard IS
779: -- SELECT 'Y'
780: -- FROM per_objectives obj
781: -- WHERE obj.scorecard_id IS NOT NULL
782: -- AND obj.scorecard_id = p_scorecard_id
783: -- AND (obj.start_date < p_start_date OR
784: -- obj.target_date > p_end_date)

Line 1278: FROM per_objectives obj

1274: l_exists varchar2(1) := 'N';
1275: --
1276: CURSOR csr_has_objectives IS
1277: SELECT 'Y'
1278: FROM per_objectives obj
1279: WHERE obj.scorecard_id IS NOT NULL
1280: AND obj.scorecard_id = p_scorecard_id
1281: AND rownum = 1;
1282: