APPS.AS_SALES_LEADS_PVT dependencies on AMS_SOURCE_CODES

Line 1003: -- FROM ams_source_codes

999: and status in ('ACTIVE','ONHOLD', 'COMPLETED');
1000:
1001:
1002: --SELECT 'X'
1003: -- FROM ams_source_codes
1004: -- WHERE source_code_id = X_promotion_id
1005: -- and active_flag = 'Y';
1006:
1007: l_val VARCHAR2(1);

Line 2006: FROM ams_source_codes

2002: IS
2003: CURSOR C_OFFER_ID_Exists (c_OFFER_ID NUMBER) IS
2004: -- the validation logic for offer_id has changed. Bug # 1915617
2005: SELECT 'X'
2006: FROM ams_source_codes
2007: WHERE source_code_id = c_offer_id
2008: and ARC_SOURCE_CODE_FOR = 'OFFR';
2009:
2010: --SELECT 'X'

Line 2019: -- FROM AMS_CAMPAIGNS_VL c, AMS_SOURCE_CODES s

2015: -- ffang 012501
2016: -- and ARC_ACT_OFFER_USED_BY = 'CAMP'
2017: -- and ACT_OFFER_USED_BY_ID =
2018: -- (SELECT CAMPAIGN_ID
2019: -- FROM AMS_CAMPAIGNS_VL c, AMS_SOURCE_CODES s
2020: -- WHERE c.SOURCE_CODE = s.SOURCE_CODE
2021: -- AND s.SOURCE_CODE_ID = P_SOURCE_PROMOTION_ID);
2022:
2023: