APPS.AHL_OSP_ORDERS_PVT dependencies on AHL_WARRANTY_CONTRACTS_B

Line 7775: AHL_WARRANTY_CONTRACTS_B AWCB,

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
7779: AND AOOL.OSP_ORDER_LINE_ID = AWSE.OSP_ORDER_LINE_ID

Line 7831: FROM ahl_warranty_contracts_b

7827: -- Cursors defined for the procedure
7828: --Cursor to fetch the active contracts for the given item instance id
7829: CURSOR c_match_contract (c_instance_id IN NUMBER) IS
7830: SELECT warranty_contract_id
7831: FROM ahl_warranty_contracts_b
7832: WHERE item_instance_id = c_instance_id
7833: AND contract_status_code = 'ACTIVE';
7834:
7835: --Cursor to check whether the item is trackable

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 7978: FROM AHL_WARRANTY_CONTRACTS_B

7974:
7975: --Cursor to fetch contract id using the contract number
7976: CURSOR c_get_contract_id (c_contract_num IN NUMBER) IS
7977: SELECT WARRANTY_CONTRACT_ID
7978: FROM AHL_WARRANTY_CONTRACTS_B
7979: WHERE CONTRACT_NUMBER = c_contract_num
7980: AND CONTRACT_STATUS_CODE = 'ACTIVE';
7981:
7982: BEGIN