DBA Data[Home] [Help]

APPS.AS_OPP_SALES_CREDIT_PVT dependencies on AS_SALES_GROUPS_V

Line 2833: FROM as_sales_groups_v

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'

Line 3123: FROM as_sales_groups_v

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';