APPS.AMS_ACTMETRIC_PVT dependencies on AMS_DELIVERABLES_ALL_B

Line 326: FROM ams_deliverables_all_b

322: --deliverable
323: CURSOR c_check_deliv_status (p_deliv_id IN NUMBER)
324: IS
325: SELECT NVL (transaction_currency_code, currency_code) AS currency_code, status_code
326: FROM ams_deliverables_all_b
327: WHERE deliverable_id = p_deliv_id;
328: --AND UPPER(status_code) IN ('SUBMITTED_BA', 'CANCELLED', 'AVAILABLE');
329:
330: --event

Line 450: FROM ams_deliverables_all_b

446: --deliverable
447: CURSOR c_check_deliv_status (p_deliv_id IN NUMBER)
448: IS
449: SELECT 1
450: FROM ams_deliverables_all_b
451: WHERE deliverable_id = p_deliv_id
452: AND UPPER(status_code) IN ('CANCELLED', 'AVAILABLE');
453:
454: --event

Line 847: FROM ams_deliverables_all_b

843:
844: -- select transaction_currency_code for deliverable
845: CURSOR c_get_delv_trans_curr(l_obj_id NUMBER) IS
846: SELECT transaction_currency_code
847: FROM ams_deliverables_all_b
848: WHERE deliverable_id = l_obj_id;
849:
850: l_obj_trans_curr VARCHAR2(15);
851: BEGIN

Line 1375: FROM ams_deliverables_all_b

1371: AND status_code = 'ACTIVE';
1372:
1373: CURSOR c_delv_active(id NUMBER) IS
1374: SELECT Fnd_Api.G_TRUE
1375: FROM ams_deliverables_all_b
1376: WHERE deliverable_id = id
1377: AND status_code IN ('SUBMITTED_BA', 'AVAILABLE');
1378:
1379: CURSOR c_eveh_active(id NUMBER) IS

Line 1408: FROM ams_deliverables_all_b

1404: AND status_code IN ('SUBMITTED_BA', 'ACTIVE', 'COMPLETED', 'CANCELLED');
1405:
1406: CURSOR c_delv_delete(id NUMBER) IS
1407: SELECT Fnd_Api.G_TRUE
1408: FROM ams_deliverables_all_b
1409: WHERE deliverable_id = id
1410: AND status_code IN ('SUBMITTED_BA', 'AVAILABLE', 'CANCELLED', 'ARCHIVED');
1411:
1412: CURSOR c_eveh_delete(id NUMBER) IS

Line 5095: FROM ams_deliverables_all_b

5091: -- select budget amounts for deliverable
5092: CURSOR c_get_deliv_budget_amounts(l_obj_id NUMBER) IS
5093: SELECT budget_amount_tc, transaction_currency_code,
5094: budget_amount_fc, functional_currency_code
5095: FROM ams_deliverables_all_b
5096: WHERE deliverable_id = l_obj_id;
5097:
5098: -- select forecasted amounts for actmetric
5099: CURSOR c_get_actmet_fore_amounts(l_obj_type VARCHAR2,

Line 7302: FROM ams_deliverables_all_b

7298: WHERE schedule_id = id;
7299:
7300: CURSOR c_check_delv(id NUMBER) IS
7301: SELECT Fnd_Api.G_TRUE
7302: FROM ams_deliverables_all_b
7303: WHERE deliverable_id = id;
7304:
7305: CURSOR c_check_eveh(id NUMBER) IS
7306: SELECT Fnd_Api.G_TRUE

Line 7526: l_table_name := 'AMS_DELIVERABLES_ALL_B';

7522: ELSIF (p_arc_act_metric_used_by ='EVEH') THEN
7523: l_table_name := 'AMS_EVENT_HEADERS_ALL_B';
7524: l_pk_name := 'EVENT_HEADER_ID';
7525: ELSIF (p_arc_act_metric_used_by ='DELV') THEN
7526: l_table_name := 'AMS_DELIVERABLES_ALL_B';
7527: l_pk_name := 'DELIVERABLE_ID';
7528: ELSIF (p_arc_act_metric_used_by = 'RCAM') THEN
7529: l_table_name := 'AMS_CAMPAIGNS_ALL_B';
7530: l_pk_name := 'CAMPAIGN_ID';

Line 7680: SELECT 1 FROM AMS_DELIVERABLES_ALL_B

7676: SELECT 1 FROM AMS_CAMPAIGN_SCHEDULES_B
7677: WHERE schedule_ID = p_campaign_schedule_id;
7678:
7679: CURSOR c_deliverable_metric(p_deliverable_id number) IS
7680: SELECT 1 FROM AMS_DELIVERABLES_ALL_B
7681: WHERE deliverable_ID = p_deliverable_id;
7682:
7683: CURSOR c_event_schedule_metric(p_event_schedule_id number) IS
7684: SELECT 1 FROM AMS_EVENT_OFFERS_ALL_B