DBA Data[Home] [Help]

APPS.OZF_ACTBUDGETS_PVT dependencies on AMS_DELIVERABLES_VL

Line 3961: l_table_name := 'AMS_DELIVERABLES_VL';

3957: l_pk_name := 'RESOURCE_ID';
3958: ELSIF p_act_budgets_rec.arc_act_budget_used_by = 'DELV' THEN
3959: -- choang - 05-sep-2000
3960: -- Fix for bug 1397577.
3961: l_table_name := 'AMS_DELIVERABLES_VL';
3962: l_pk_name := 'DELIVERABLE_ID';
3963: ELSIF p_act_budgets_rec.arc_act_budget_used_by = 'CSCH' THEN
3964: l_table_name := 'AMS_CAMPAIGN_SCHEDULES_VL';
3965: l_pk_name := 'SCHEDULE_ID';

Line 4041: l_table_name := 'AMS_DELIVERABLES_VL';

4037: l_table_name := 'ams_jtf_rs_emp_v';
4038: l_pk_name := 'RESOURCE_ID';
4039: -- 03/21/2002 mpande added because Deliverables reconciliation was not working properly
4040: ELSIF p_act_budgets_rec.budget_source_type = 'DELV' THEN
4041: l_table_name := 'AMS_DELIVERABLES_VL';
4042: l_pk_name := 'DELIVERABLE_ID';
4043: END IF;
4044:
4045: l_pk_value := p_act_budgets_rec.budget_source_id;

Line 5218: FROM ams_deliverables_vl

5214: WHERE event_offer_id = p_object_id;
5215:
5216: CURSOR c_deliverable IS
5217: SELECT transaction_currency_code
5218: FROM ams_deliverables_vl
5219: WHERE deliverable_id = p_object_id;
5220:
5221: CURSOR c_fund IS
5222: SELECT currency_code_tc