APPS.AMS_CAMPAIGN_PVT dependencies on DUAL

Line 54: FROM DUAL;

50: l_org_id NUMBER;
51:
52: CURSOR c_camp_seq IS
53: SELECT ams_campaigns_all_b_s.NEXTVAL
54: FROM DUAL;
55:
56: CURSOR c_camp_count(camp_id IN NUMBER) IS
57: SELECT COUNT(*)
58: FROM ams_campaigns_vl

Line 2489: IS SELECT 1 from dual

2485: l_pk_data_type VARCHAR2(30);
2486: l_where_clause VARCHAR2(2000);
2487:
2488: CURSOR c_prog_name
2489: IS SELECT 1 from dual
2490: WHERE EXISTS ( SELECT * from ams_campaigns_vl
2491: WHERE rollup_type = 'RCAM'
2492: AND UPPER(campaign_name) = UPPER(p_complete_rec.campaign_name)) ;
2493: CURSOR c_prog_name_updt

Line 2494: IS SELECT 1 from dual

2490: WHERE EXISTS ( SELECT * from ams_campaigns_vl
2491: WHERE rollup_type = 'RCAM'
2492: AND UPPER(campaign_name) = UPPER(p_complete_rec.campaign_name)) ;
2493: CURSOR c_prog_name_updt
2494: IS SELECT 1 from dual
2495: WHERE EXISTS ( SELECT * from ams_campaigns_vl
2496: WHERE rollup_type = 'RCAM'
2497: AND UPPER(campaign_name) = UPPER(p_complete_rec.campaign_name)
2498: AND campaign_id <> p_complete_rec.campaign_id );