2829: IS
2830:
2831: CURSOR C_SALES_GROUP_ID_Exists(c_SALES_GROUP_ID NUMBER) IS
2832: SELECT 'X'
2833: FROM as_sales_groups_v
2834: WHERE SALES_GROUP_ID = c_SALES_GROUP_ID;
2835:
2836: CURSOR C_PRTNR_SALES_GROUP_ID_Exists(c_SALES_GROUP_ID NUMBER) IS
2837: SELECT 'X'
3119: AND salesforce_id = X_Salesforce_Id;
3120:
3121: CURSOR C_Salesgroup_Exists (X_Sales_Group_Id NUMBER) IS
3122: SELECT 'X'
3123: FROM as_sales_groups_v
3124: WHERE sales_group_id = X_Sales_Group_Id;
3125:
3126: l_val VARCHAR2(1);
3127: l_api_name CONSTANT VARCHAR2(30) := 'Validate_sales_credit_rec';