DBA Data[Home] [Help]

APPS.AMS_APPROVAL_PVT dependencies on OZF_FUNDS_ALL_VL

Line 831: FROM ozf_funds_all_vl

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,

Line 3629: FROM ozf_funds_all_vl

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