APPS.AMS_ACTMETRICS_ENGINE_PVT dependencies on AMS_DELIVERABLES_ALL_B

Line 3656: FROM ams_deliverables_all_b

3652: AND status_code = G_CANCELLED;
3653:
3654: CURSOR c_delv(id NUMBER) IS
3655: SELECT Fnd_Api.G_TRUE
3656: FROM ams_deliverables_all_b
3657: WHERE deliverable_id = id
3658: AND status_code = G_CANCELLED;
3659:
3660: CURSOR c_eveh(id NUMBER) IS

Line 4249: FROM ams_deliverables_all_b

4245: return object_detail_type IS
4246: SELECT G_DELV, deliverable_id, transaction_currency_code, NULL, NULL,
4247: decode(status_code, G_CANCELLED, Fnd_Api.G_TRUE, Fnd_Api.G_FALSE) cancelled_flag,
4248: G_SHOW
4249: FROM ams_deliverables_all_b
4250: WHERE deliverable_id = l_act_metric_used_by_id;
4251:
4252: CURSOR c_check_act_list(l_act_metric_used_by_id NUMBER)
4253: return object_detail_type IS

Line 4488: FROM ams_deliverables_all_b

4484: ORDER BY obj_type, obj_id;
4485:
4486: CURSOR c_get_deliv (p_deliverable_id NUMBER) IS
4487: SELECT deliverable_id obj_id, G_DELV obj_type, transaction_currency_code currency
4488: FROM ams_deliverables_all_b
4489: WHERE deliverable_id = p_deliverable_id;
4490:
4491: CURSOR c_get_act_list (p_act_list_header_id NUMBER) IS
4492: SELECT act_list_header_id obj_id, G_ALIST obj_type, Ams_Actmetric_Pvt.DEFAULT_FUNC_CURRENCY currency