APPS.CN_PLAN_TEXTS_PVT dependencies on CN_SRP_ROLE_DTLS_V

Line 11: FROM cn_srp_role_dtls_v s, cn_role_quota_cates r

7:
8:
9: CURSOR validate_role_state (c_role_id IN NUMBER) IS
10: SELECT 1
11: FROM cn_srp_role_dtls_v s, cn_role_quota_cates r
12: WHERE s.status not in ('PENDING','ACCEPTED')
13: AND s.role_id = r.role_id
14: AND r.role_model_id is NULL
15: AND s.role_model_id is NULL

Line 572: FROM cn_srp_role_dtls_v

568: l_ctr NUMBER;
569:
570: CURSOR l_spt_cr (P_ROLE_ID NUMBER) IS
571: SELECT srp_id
572: FROM cn_srp_role_dtls_v
573: WHERE role_id = P_ROLE_ID
574: AND role_model_id is NULL
575: AND (status <> 'PENDING' or non_std_flag = 'Y' );
576: