69: WHERE deliverable_id = p_object_id;
70:
71: CURSOR c_fund IS
72: SELECT owner, short_name, status_code
73: FROM ozf_funds_all_vl
74: WHERE fund_id = p_object_id;
75:
76: BEGIN
77: x_object_owner := '-';
359:
360: CURSOR c_get_child_funds IS
361: SELECT fund_id, short_name, status_code, owner,
362: decode(status_code, 'DRAFT', 'Y', 'REJECTED', 'Y', 'ARCHIVED', 'Y', 'N') deletable_flag
363: FROM ozf_funds_all_vl
364: WHERE parent_fund_id = p_object_id;
365:
366: CURSOR c_resource(p_owner_id NUMBER) IS
367: SELECT full_name
764: , -rollup_recal_committed
765: , status_code
766: , fund_type
767:
768: FROM ozf_funds_all_vl
769: WHERE fund_id = p_object_id
770: AND object_version_number = p_object_version_number;
771:
772: --ninarasi fix for motorola bug 13054588