APPS.CN_PLAN_TEXTS_PVT dependencies on CN_ROLE_QUOTA_CATES

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 795: cn_role_quota_cates pqc

791: C_ROLE_MODEL_ID IN NUMBER) IS
792: SELECT qc.quota_category_id quota_cate_id,
793: qc.name quota_name
794: FROM cn_quota_categories qc,
795: cn_role_quota_cates pqc
796: WHERE pqc.role_id = c_role_id
797: AND qc.quota_category_id = pqc.quota_category_id
798: AND qc.type = 'FIXED'
799: AND nvl(pqc.role_model_id, -1) = nvl(c_role_model_id, -1)

Line 930: cn_role_quota_cates pqc

926: c_role_model_id IN NUMBER) IS
927: SELECT qc.quota_category_id quota_cate_id,
928: qc.name quota_name
929: FROM cn_quota_categories qc,
930: cn_role_quota_cates pqc
931: WHERE pqc.role_id = c_role_id
932: and (NOT pqc.rate_schedule_id IS NULL)
933: and qc.quota_category_id = pqc.quota_category_id
934: and qc.type = 'VAR_QUOTA'

Line 1078: cn_role_quota_cates pqc

1074: c_quota_cate_type IN VARCHAR) IS
1075: SELECT qc.quota_category_id quota_cate_id,
1076: qc.name quota_name
1077: FROM cn_quota_categories qc,
1078: cn_role_quota_cates pqc
1079: WHERE pqc.role_id = c_role_id
1080: and (NOT pqc.rate_schedule_id IS NULL)
1081: and qc.quota_category_id = pqc.quota_category_id
1082: and qc.type = c_quota_cate_type