APPS.AMS_WFCMPAPR_PVT dependencies on AMS_CAMPAIGNS_VL

Line 385: FROM ams_campaigns_vl

381:
382:
383: CURSOR c_camp_det(l_camp_id NUMBER) IS
384: SELECT owner_user_id
385: FROM ams_campaigns_vl
386: WHERE campaign_id = l_camp_id ;
387:
388:
389: -- Added By ptendulk on 28 Jan 2000, The Owner

Line 396: FROM ams_campaigns_vl

392:
393: l_parent_id NUMBER;
394: CURSOR c_parent_camp IS
395: SELECT parent_campaign_id
396: FROM ams_campaigns_vl
397: WHERE campaign_id = p_activity_id ;
398:
399: CURSOR c_deli_det IS
400: SELECT owner_user_id

Line 586: FROM ams_campaigns_vl

582:
583: CURSOR c_camp_det IS
584: SELECT fund_source_type,
585: fund_source_id
586: FROM ams_campaigns_vl
587: WHERE campaign_id = p_activity_id ;
588:
589: CURSOR c_deli_det IS
590: SELECT fund_source_type,

Line 664: FROM ams_campaigns_vl

660: WHERE fund_id = l_source_id ;
661:
662: CURSOR c_camp_det IS
663: SELECT owner_user_id
664: FROM ams_campaigns_vl
665: WHERE campaign_id = l_source_id ;
666:
667: CURSOR c_deli_det IS
668: SELECT owner_user_id

Line 2908: FROM ams_campaigns_vl

2904:
2905: CURSOR c_camp_priority
2906: IS
2907: SELECT priority
2908: FROM ams_campaigns_vl
2909: WHERE campaign_id = p_obj_id ;
2910:
2911: CURSOR c_eveh_priority
2912: IS

Line 3036: FROM ams_jtf_rs_emp_v jtf,ams_campaigns_vl camp

3032: -- on 08-Jun-2000
3033: CURSOR c_camp_owner(l_id NUMBER)
3034: IS
3035: SELECT jtf.full_name
3036: FROM ams_jtf_rs_emp_v jtf,ams_campaigns_vl camp
3037: WHERE camp.campaign_id = l_id
3038: AND jtf.resource_id = camp.owner_user_id ;
3039:
3040: CURSOR c_eveh_owner(l_id NUMBER)

Line 3452: FROM ams_campaigns_vl camp

3448: camp.actual_exec_end_date,
3449: camp.description,
3450: camp.transaction_currency_code,
3451: camp.budget_amount_tc
3452: FROM ams_campaigns_vl camp
3453: WHERE camp.campaign_id = l_my_campaign_id ;
3454:
3455: CURSOR C_camp_geo(l_my_campaign_id VARCHAR2
3456: ) IS