515: WHERE campaign_id = p_object_id;
516:
517: CURSOR c_campaign_schl (p_object_id IN NUMBER) IS
518: SELECT custom_setup_id, owner_user_id
519: FROM ams_campaign_schedules_vl
520: WHERE schedule_id = p_object_id;
521:
522: CURSOR c_eheader (p_object_id IN NUMBER) IS
523: SELECT setup_type_id, owner_user_id
734: WHERE campaign_id = p_object_id;
735:
736: CURSOR c_campaign_schl IS
737: SELECT budget_amount_tc, status_code
738: FROM ams_campaign_schedules_vl
739: WHERE schedule_id = p_object_id;
740:
741: CURSOR c_eheader IS
742: SELECT fund_amount_tc, system_status_code