516: )
517: RETURN VARCHAR2 IS
518: CURSOR c_campaign (p_object_id IN NUMBER) IS
519: SELECT custom_setup_id, owner_user_id
520: FROM ams_campaigns_vl
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
735: )
736: RETURN VARCHAR2 IS
737: CURSOR c_campaign IS
738: SELECT budget_amount_tc, status_code
739: FROM ams_campaigns_vl
740: WHERE campaign_id = p_object_id;
741:
742: CURSOR c_campaign_schl IS
743: SELECT budget_amount_tc, status_code