APPS.AS_IMPORT_SL_PVT dependencies on AMS_P_SOURCE_CODES_V

Line 2370: FROM ams_p_source_codes_v

2366: l_dummy_tbl9 as_sales_leads_pub.sales_lead_contact_tbl_type;
2367:
2368: CURSOR c_get_source_code (c_promotion_id number) IS
2369: SELECT source_code_id, source_code
2370: FROM ams_p_source_codes_v
2371: WHERE source_code_id = c_promotion_id
2372: AND source_type in ('CAMP','CSCH','EONE', 'EVEH','EVEO')
2373: AND status in ('ACTIVE','ONHOLD', 'COMPLETED');
2374:

Line 2377: -- SOLIN, bug 4927392, use view ams_p_source_codes_v

2373: AND status in ('ACTIVE','ONHOLD', 'COMPLETED');
2374:
2375: CURSOR c_get_promotion_id (c_promotion_code VARCHAR2) IS
2376: SELECT source_code_id
2377: -- SOLIN, bug 4927392, use view ams_p_source_codes_v
2378: FROM ams_p_source_codes_v
2379: WHERE upper(source_code) = upper(c_promotion_code)
2380: AND source_type in ('CAMP','CSCH','EONE', 'EVEH','EVEO')
2381: AND status in ('ACTIVE','ONHOLD', 'COMPLETED');

Line 2378: FROM ams_p_source_codes_v

2374:
2375: CURSOR c_get_promotion_id (c_promotion_code VARCHAR2) IS
2376: SELECT source_code_id
2377: -- SOLIN, bug 4927392, use view ams_p_source_codes_v
2378: FROM ams_p_source_codes_v
2379: WHERE upper(source_code) = upper(c_promotion_code)
2380: AND source_type in ('CAMP','CSCH','EONE', 'EVEH','EVEO')
2381: AND status in ('ACTIVE','ONHOLD', 'COMPLETED');
2382: