DBA Data[Home] [Help]

APPS.AMS_ASSOCIATIONS_PVT dependencies on AMS_DELIVERABLES_ALL_B

Line 82: FROM ams_deliverables_all_b

78: WHERE schedule_id = l_camp_sch_id;
79:
80: CURSOR c_get_delv_details(l_delv_id IN NUMBER) IS
81: SELECT actual_avail_from_date,actual_avail_to_date,language_code
82: FROM ams_deliverables_all_b
83: WHERE deliverable_id = l_delv_id;
84:
85: l_csch_lang_code VARCHAR2(30);
86: l_delv_lang_code VARCHAR2(30);

Line 1228: THEN l_foreign_table := 'AMS_DELIVERABLES_ALL_B';

1224: ELSIF p_using_type = 'CAMP'
1225: THEN l_foreign_table := 'AMS_CAMPAIGNS_ALL_B';
1226: l_foreign_table_id := 'CAMPAIGN_ID';
1227: ELSIF p_using_type = 'DELV'
1228: THEN l_foreign_table := 'AMS_DELIVERABLES_ALL_B';
1229: l_foreign_table_id := 'DELIVERABLE_ID';
1230: ELSE
1231: return FND_API.g_false;
1232: END IF;