APPS.AS_OPP_HEADER_PVT dependencies on AMS_SOURCE_CODES

Line 3603: FROM ams_source_codes

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

Line 3642: -- SOURCE_PROMOTION_ID should exist in ams_source_codes

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

Line 4173: FROM ams_source_codes

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

Line 4184: -- FROM AMS_CAMPAIGNS_VL c, AMS_SOURCE_CODES s

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