[Home] [Help]
827: '' priority_desc,
828: '' source_code,
829: '' parent_source_code,
830: '' parent_name
831: FROM ozf_funds_all_vl
832: WHERE fund_id = p_activity_id;
833: ELSIF p_activity_type = 'DELV' THEN
834: OPEN l_obj_details FOR
835: SELECT deliverable_name,
3625: FROM ams_deliverables_vl
3626: WHERE deliverable_id = p_object_id;
3627: CURSOR c_fund IS
3628: SELECT currency_code_tc
3629: FROM ozf_funds_all_vl
3630: WHERE fund_id = p_object_id;
3631: BEGIN
3632: -- Campaign
3633: IF p_object = 'CAMP' THEN