536: WHERE event_offer_id = p_object_id;
537:
538: CURSOR c_deliverable (p_object_id IN NUMBER) IS
539: SELECT custom_setup_id, owner_user_id
540: FROM ams_deliverables_vl
541: WHERE deliverable_id = p_object_id;
542:
543: CURSOR c_fund (p_object_id IN NUMBER) IS
544: SELECT custom_setup_id, owner
755: WHERE event_offer_id = p_object_id;
756:
757: CURSOR c_deliverable IS
758: SELECT budget_amount_tc, status_code
759: FROM ams_deliverables_vl
760: WHERE deliverable_id = p_object_id;
761:
762: -- this amount column would change
763: CURSOR c_offer IS