APPS.AHL_OSP_ORDERS_PVT dependencies on AHL_WARRANTY_ENTITLEMENTS

Line 7774: FROM AHL_WARRANTY_ENTITLEMENTS AWSE,

7770: IS
7771: -- Cursor to check the condition
7772: CURSOR c_can_show_claim (c_osp_order_line_id IN NUMBER) IS
7773: SELECT 'X'
7774: FROM AHL_WARRANTY_ENTITLEMENTS AWSE,
7775: AHL_WARRANTY_CONTRACTS_B AWCB,
7776: AHL_OSP_ORDERS_B AOOB,
7777: AHL_OSP_ORDER_LINES AOOL
7778: WHERE AOOB.OSP_ORDER_ID = AOOL.OSP_ORDER_ID

Line 7845: FROM AHL_WARRANTY_ENTITLEMENTS ASWE

7841:
7842: --Cursor to fetch entitlement id for a given workorder
7843: CURSOR c_get_entl_for_wo(c_workorder_id NUMBER) IS
7844: SELECT ASWE.WARRANTY_ENTITLEMENT_ID, ASWE.OBJECT_VERSION_NUMBER
7845: FROM AHL_WARRANTY_ENTITLEMENTS ASWE
7846: WHERE ASWE.VISIT_TASK_ID = (SELECT wo.visit_task_id
7847: FROM ahl_workorders wo
7848: WHERE wo.workorder_id = c_workorder_id);
7849:

Line 7971: FROM AHL_WARRANTY_ENTITLEMENTS AWSE, AHL_WARRANTY_CONTRACTS_B AWCB

7967: -- Cursors defined for the procedure
7968: --Cursor to fetch the entitlement values from DB
7969: CURSOR c_old_entitlement_rec (c_osp_order_line_id IN NUMBER) IS
7970: SELECT AWCB.WARRANTY_CONTRACT_ID, AWSE.ENTITLEMENT_STATUS_CODE, AWSE.OBJECT_VERSION_NUMBER
7971: FROM AHL_WARRANTY_ENTITLEMENTS AWSE, AHL_WARRANTY_CONTRACTS_B AWCB
7972: WHERE AWSE.WARRANTY_CONTRACT_ID = AWCB.WARRANTY_CONTRACT_ID(+)
7973: AND AWSE.OSP_ORDER_LINE_ID = c_osp_order_line_id;
7974:
7975: --Cursor to fetch contract id using the contract number

Line 8124: FROM AHL_WARRANTY_ENTITLEMENTS AWSE

8120: -- Cursors defined for the procedure
8121: --Cursor to get entitlement details
8122: CURSOR c_get_entl_details (c_osp_order_line_id IN NUMBER) IS
8123: SELECT AWSE.WARRANTY_ENTITLEMENT_ID, AWSE.VISIT_TASK_ID, AWSE.OBJECT_VERSION_NUMBER
8124: FROM AHL_WARRANTY_ENTITLEMENTS AWSE
8125: WHERE AWSE.OSP_ORDER_LINE_ID = c_osp_order_line_id;
8126:
8127: --Cursor to fetch osp lines for a given osp order
8128: CURSOR c_get_osp_lines (c_osp_order_id IN NUMBER) IS