DBA Data[Home] [Help]

APPS.AMS_WFTRIG_PVT dependencies on AMS_CAMPAIGNS_VL

Line 69: FROM ams_campaigns_vl

65: IS
66:
67: CURSOR c_camp_det IS
68: SELECT owner_user_id
69: FROM ams_campaigns_vl
70: WHERE campaign_id = p_activity_id ;
71:
72: CURSOR c_csch_det IS
73: SELECT owner_user_id

Line 3383: FROM ams_campaigns_vl

3379: -- The Campaign_owner Username has tobe selected from jtf_resource_extn_vl
3380: -- Has to be changed once the view is modified
3381: CURSOR c_camp_det IS
3382: SELECT campaign_name, priority, owner_user_id
3383: FROM ams_campaigns_vl
3384: WHERE campaign_id = l_trig_rec.trigger_created_for_id ;
3385:
3386: CURSOR c_csch_det IS
3387: SELECT schedule_name, priority, owner_user_id