APPS.CSC_PROF_MODULE_GROUPS_PVT dependencies on CSC_PROF_GROUPS_VL

Line 885: from csc_prof_groups_vl

881: p_Api_Name VARCHAR2(100) := 'Validate_Group_Id';
882: --keep an UNION fo r ALL party type..
883: Cursor C1 is
884: Select NULL
885: from csc_prof_groups_vl
886: where group_id = P_GROUP_ID
887: and party_type = p_party_type
888: and nvl(use_in_customer_dashboard,'Y') = 'N'
889: UNION

Line 891: from csc_prof_groups_vl

887: and party_type = p_party_type
888: and nvl(use_in_customer_dashboard,'Y') = 'N'
889: UNION
890: Select NULL
891: from csc_prof_groups_vl
892: where group_id = P_GROUP_ID
893: and party_type = 'ALL'
894: and nvl(use_in_customer_dashboard,'Y') = 'N';
895: BEGIN

Line 1111: from csc_prof_groups_vl

1107: where function_id = c_form_function_id;
1108: /*
1109: Cursor C2 (c_group_id number) is
1110: Select use_in_customer_dashboard
1111: from csc_prof_groups_vl
1112: where group_id = c_group_id;
1113: */
1114:
1115: /* BUG 1806606 - SRP2:PREFERENCES- MULTI-RECORDS (SAME TYPE) CAN BE SAVED

Line 1216: from csc_prof_groups_vl

1212: p_Api_Name VARCHAR2(100) := 'Validate_Dashboard_Group_Id';
1213: --keep an UNION fo r ALL party type..
1214: Cursor C1 is
1215: Select NULL
1216: from csc_prof_groups_vl
1217: where group_id = P_DASHBOARD_GROUP_ID
1218: and party_type = p_party_type
1219: and nvl(use_in_customer_dashboard,'N') = 'Y'
1220: UNION

Line 1222: from csc_prof_groups_vl

1218: and party_type = p_party_type
1219: and nvl(use_in_customer_dashboard,'N') = 'Y'
1220: UNION
1221: Select NULL
1222: from csc_prof_groups_vl
1223: where group_id = P_DASHBOARD_GROUP_ID
1224: and party_type = 'ALL'
1225: and nvl(use_in_customer_dashboard,'N') = 'Y';
1226: BEGIN