APPS.CN_PLAN_TEXTS_PVT dependencies on CN_QUOTA_CATEGORIES

Line 794: FROM cn_quota_categories qc,

790: CURSOR l_qcs_cr (C_ROLE_ID IN NUMBER,
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'

Line 929: FROM cn_quota_categories qc,

925: CURSOR l_qcs_cr(c_role_id IN NUMBER,
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

Line 1077: FROM cn_quota_categories qc,

1073: c_role_model_id IN NUMBER,
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