APPS.AS_SALES_LEADS_PVT dependencies on AMS_P_SOURCE_CODES_V

Line 996: FROM ams_p_source_codes_v

992: IS
993:
994: CURSOR C_Promotion_Exists (X_Promotion_Id NUMBER) IS
995: SELECT 'X'
996: FROM ams_p_source_codes_v
997: WHERE source_code_id = X_promotion_id
998: and source_type in ('CAMP','CSCH','EONE', 'EVEH','EVEO')
999: and status in ('ACTIVE','ONHOLD', 'COMPLETED');
1000: