APPS.AS_OPP_HEADER_PVT dependencies on AMS_SOURCE_CODES

Line 3602: FROM ams_source_codes

3598: )
3599: IS
3600: CURSOR C_SOURCE_PROMOTION_ID_Exists (c_Source_Code_ID VARCHAR2) IS
3601: SELECT 'X'
3602: FROM ams_source_codes
3603: WHERE source_code_id = c_Source_Code_ID
3604: -- and active_flag = 'Y'
3605: and ARC_SOURCE_CODE_FOR <> 'OFFR';
3606: -- nkamble commented below line and put OFFR condition for bug#3133993

Line 3641: -- SOURCE_PROMOTION_ID should exist in ams_source_codes

3637:
3638: IF (p_SOURCE_PROMOTION_ID is NOT NULL )AND
3639: (p_SOURCE_PROMOTION_ID <> FND_API.G_MISS_NUM)
3640: THEN
3641: -- SOURCE_PROMOTION_ID should exist in ams_source_codes
3642: OPEN C_SOURCE_PROMOTION_ID_Exists (p_SOURCE_PROMOTION_ID);
3643: FETCH C_SOURCE_PROMOTION_ID_Exists into l_val;
3644:
3645: IF C_SOURCE_PROMOTION_ID_Exists%NOTFOUND THEN

Line 4172: FROM ams_source_codes

4168: IS
4169:
4170: CURSOR C_OFFER_ID_Exists (c_OFFER_ID NUMBER) IS
4171: SELECT 'X'
4172: FROM ams_source_codes
4173: WHERE source_code_id = c_offer_id
4174: and ARC_SOURCE_CODE_FOR = 'OFFR';
4175:
4176: --

Line 4183: -- FROM AMS_CAMPAIGNS_VL c, AMS_SOURCE_CODES s

4179: -- ffang 012501
4180: -- and ARC_ACT_OFFER_USED_BY = 'CAMP'
4181: -- and ACT_OFFER_USED_BY_ID =
4182: -- (SELECT CAMPAIGN_ID
4183: -- FROM AMS_CAMPAIGNS_VL c, AMS_SOURCE_CODES s
4184: -- WHERE c.SOURCE_CODE = s.SOURCE_CODE
4185: -- AND s.SOURCE_CODE_ID = P_SOURCE_PROMOTION_ID);
4186:
4187: l_val VARCHAR2(1);