APPS.AHL_VWP_RULES_PVT dependencies on AHL_WARRANTY_CONTRACTS_B

Line 4040: FROM AHL_WARRANTY_ENTITLEMENTS AWSE, AHL_WARRANTY_CONTRACTS_B AWCB

4036: --cursor to fetch the old entitlemet record from DB for the task
4037: CURSOR c_old_entitlement_rec (c_task_id IN NUMBER) IS
4038: SELECT AWCB.WARRANTY_CONTRACT_ID, AWCB.CONTRACT_NUMBER
4039: , AWSE.ENTITLEMENT_STATUS_CODE, AWSE.OBJECT_VERSION_NUMBER
4040: FROM AHL_WARRANTY_ENTITLEMENTS AWSE, AHL_WARRANTY_CONTRACTS_B AWCB
4041: WHERE AWSE.WARRANTY_CONTRACT_ID = AWCB.WARRANTY_CONTRACT_ID(+)
4042: AND AWSE.VISIT_TASK_ID = c_task_id;
4043:
4044: --cursor to fetch active contract id using contract number

Line 4047: FROM AHL_WARRANTY_CONTRACTS_B

4043:
4044: --cursor to fetch active contract id using contract number
4045: CURSOR c_get_contract_id (c_contract_num IN NUMBER) IS
4046: SELECT WARRANTY_CONTRACT_ID
4047: FROM AHL_WARRANTY_CONTRACTS_B
4048: WHERE CONTRACT_STATUS_CODE = 'ACTIVE'
4049: AND CONTRACT_NUMBER = c_contract_num;
4050:
4051: --cursor to check if a record exists in the entitlements for the given work order

Line 4608: AHL_WARRANTY_CONTRACTS_B AWCB,

4604: 'Y' WARRANTY_NOT_APPL_FLAG
4605: FROM AHL_VISIT_TASKS_B ATSK,
4606: AHL_WARRANTY_ENTITLEMENTS ASWE,
4607: AHL_WARRANTY_CLAIMS_B AWCL,
4608: AHL_WARRANTY_CONTRACTS_B AWCB,
4609: FND_LOOKUP_VALUES_VL LKUP1,
4610: FND_LOOKUP_VALUES_VL LKUP2
4611: WHERE ATSK.VISIT_TASK_ID = ASWE.VISIT_TASK_ID(+)
4612: AND ASWE.WARRANTY_CONTRACT_ID = AWCB.WARRANTY_CONTRACT_ID(+)