APPS.PER_PMS_BUS dependencies on PER_OBJECTIVES

Line 779: FROM per_objectives obj

775: WHERE pmp.plan_id = p_plan_id;
776:
777: CURSOR csr_objs_outside_scorecard IS
778: SELECT 'Y'
779: FROM per_objectives obj
780: WHERE obj.scorecard_id IS NOT NULL
781: AND obj.scorecard_id = p_scorecard_id
782: AND (obj.start_date < p_start_date OR
783: obj.target_date > p_end_date)

Line 1215: FROM per_objectives obj

1211: l_exists varchar2(1) := 'N';
1212: --
1213: CURSOR csr_has_objectives IS
1214: SELECT 'Y'
1215: FROM per_objectives obj
1216: WHERE obj.scorecard_id IS NOT NULL
1217: AND obj.scorecard_id = p_scorecard_id
1218: AND rownum = 1;
1219: