521: WHERE campaign_id = p_object_id;
522:
523: CURSOR c_campaign_schl (p_object_id IN NUMBER) IS
524: SELECT custom_setup_id, owner_user_id
525: FROM ams_campaign_schedules_vl
526: WHERE schedule_id = p_object_id;
527:
528: CURSOR c_eheader (p_object_id IN NUMBER) IS
529: SELECT setup_type_id, owner_user_id
740: WHERE campaign_id = p_object_id;
741:
742: CURSOR c_campaign_schl IS
743: SELECT budget_amount_tc, status_code
744: FROM ams_campaign_schedules_vl
745: WHERE schedule_id = p_object_id;
746:
747: CURSOR c_eheader IS
748: SELECT fund_amount_tc, system_status_code