DBA Data[Home] [Help]

APPS.OZF_ACTBUDGETS_PVT dependencies on AMS_DELIVERABLES_VL

Line 3144: l_table_name := 'AMS_DELIVERABLES_VL';

3140: l_pk_name := 'RESOURCE_ID';
3141: ELSIF p_act_budgets_rec.arc_act_budget_used_by = 'DELV' THEN
3142: -- choang - 05-sep-2000
3143: -- Fix for bug 1397577.
3144: l_table_name := 'AMS_DELIVERABLES_VL';
3145: l_pk_name := 'DELIVERABLE_ID';
3146: ELSIF p_act_budgets_rec.arc_act_budget_used_by = 'CSCH' THEN
3147: l_table_name := 'AMS_CAMPAIGN_SCHEDULES_VL';
3148: l_pk_name := 'SCHEDULE_ID';

Line 3224: l_table_name := 'AMS_DELIVERABLES_VL';

3220: l_table_name := 'ams_jtf_rs_emp_v';
3221: l_pk_name := 'RESOURCE_ID';
3222: -- 03/21/2002 mpande added because Deliverables reconciliation was not working properly
3223: ELSIF p_act_budgets_rec.budget_source_type = 'DELV' THEN
3224: l_table_name := 'AMS_DELIVERABLES_VL';
3225: l_pk_name := 'DELIVERABLE_ID';
3226: END IF;
3227:
3228: l_pk_value := p_act_budgets_rec.budget_source_id;

Line 4401: FROM ams_deliverables_vl

4397: WHERE event_offer_id = p_object_id;
4398:
4399: CURSOR c_deliverable IS
4400: SELECT transaction_currency_code
4401: FROM ams_deliverables_vl
4402: WHERE deliverable_id = p_object_id;
4403:
4404: CURSOR c_fund IS
4405: SELECT currency_code_tc