APPS.AMS_ACTMETRIC_PVT dependencies on AMS_EVENT_HEADERS_ALL_B

Line 335: FROM ams_event_headers_all_b

331: CURSOR c_check_event_status (p_event_id IN NUMBER)
332: IS
333: SELECT currency_code_tc AS currency_code, system_status_code
334: -- active_flag, active_from_date
335: FROM ams_event_headers_all_b
336: WHERE event_header_id = p_event_id;
337: --AND active_flag = 'Y'
338: --AND active_from_date < SYSDATE;
339:

Line 458: FROM ams_event_headers_all_b

454: --event
455: CURSOR c_check_event_status (p_event_id IN NUMBER)
456: IS
457: SELECT 1
458: FROM ams_event_headers_all_b
459: WHERE event_header_id = p_event_id
460: AND UPPER(system_status_code) IN
461: ('ACTIVE', 'AVAILABLE', 'CANCELLED', 'PLANNING')
462: --AND active_flag = 'Y'

Line 841: FROM ams_event_headers_all_b

837:
838: -- select transaction_currency_code for event header
839: CURSOR c_get_eveh_trans_curr(l_obj_id NUMBER) IS
840: SELECT currency_code_tc
841: FROM ams_event_headers_all_b
842: WHERE event_header_id = l_obj_id;
843:
844: -- select transaction_currency_code for deliverable
845: CURSOR c_get_delv_trans_curr(l_obj_id NUMBER) IS

Line 1381: FROM ams_event_headers_all_b

1377: AND status_code IN ('SUBMITTED_BA', 'AVAILABLE');
1378:
1379: CURSOR c_eveh_active(id NUMBER) IS
1380: SELECT Fnd_Api.G_TRUE
1381: FROM ams_event_headers_all_b
1382: WHERE event_header_id = id
1383: AND system_status_code IN ('ACTIVE', 'SUBMITTED_BA');
1384:
1385: CURSOR c_eveo_active(id NUMBER) IS

Line 1414: FROM ams_event_headers_all_b

1410: AND status_code IN ('SUBMITTED_BA', 'AVAILABLE', 'CANCELLED', 'ARCHIVED');
1411:
1412: CURSOR c_eveh_delete(id NUMBER) IS
1413: SELECT Fnd_Api.G_TRUE
1414: FROM ams_event_headers_all_b
1415: WHERE event_header_id = id
1416: AND system_status_code IN ('ACTIVE', 'CANCELLED', 'SUBMITTED_BA','COMPLETED');
1417:
1418: CURSOR c_eveo_delete(id NUMBER) IS

Line 5080: FROM ams_event_headers_all_b

5076: -- select budget amounts for event header
5077: CURSOR c_get_evehd_budget_amounts(l_obj_id NUMBER) IS
5078: SELECT fund_amount_tc, currency_code_tc,
5079: fund_amount_fc, currency_code_fc
5080: FROM ams_event_headers_all_b
5081: WHERE event_header_id = l_obj_id;
5082:
5083: -- select budget amounts for deliverable
5084: CURSOR c_get_deliv_budget_amounts(l_obj_id NUMBER) IS

Line 7299: FROM ams_event_headers_all_b

7295: WHERE deliverable_id = id;
7296:
7297: CURSOR c_check_eveh(id NUMBER) IS
7298: SELECT Fnd_Api.G_TRUE
7299: FROM ams_event_headers_all_b
7300: WHERE event_header_id = id;
7301:
7302: CURSOR c_check_eveo(id NUMBER) IS
7303: SELECT Fnd_Api.G_TRUE

Line 7515: l_table_name := 'AMS_EVENT_HEADERS_ALL_B';

7511: ELSIF (p_arc_act_metric_used_by ='EONE') THEN
7512: l_table_name := 'AMS_EVENT_OFFERS_ALL_B';
7513: l_pk_name := 'EVENT_OFFER_ID';
7514: ELSIF (p_arc_act_metric_used_by ='EVEH') THEN
7515: l_table_name := 'AMS_EVENT_HEADERS_ALL_B';
7516: l_pk_name := 'EVENT_HEADER_ID';
7517: ELSIF (p_arc_act_metric_used_by ='DELV') THEN
7518: l_table_name := 'AMS_DELIVERABLES_ALL_B';
7519: l_pk_name := 'DELIVERABLE_ID';

Line 7687: SELECT 1 FROM AMS_EVENT_HEADERS_ALL_B

7683: and event_object_type = 'EONE';
7684:
7685:
7686: CURSOR c_event_metric(p_event_id number) IS
7687: SELECT 1 FROM AMS_EVENT_HEADERS_ALL_B
7688: WHERE EVENT_HEADER_ID = p_event_id;
7689:
7690:
7691: CURSOR c_act_list_metric(p_act_list_id number) IS