DBA Data[Home] [Help]

APPS.AHL_VWP_RULES_PVT dependencies on AHL_WARRANTY_CONTRACTS_VL

Line 3853: FROM AHL_WARRANTY_CONTRACTS_VL AWCV

3849:
3850: --cursor to fetch active warranty contract of an instance for a given template
3851: CURSOR c_match_contract (c_instance_id IN NUMBER, c_warranty_templ_id IN NUMBER) IS
3852: SELECT AWCV.WARRANTY_CONTRACT_ID
3853: FROM AHL_WARRANTY_CONTRACTS_VL AWCV
3854: WHERE AWCV.CONTRACT_STATUS_CODE = 'ACTIVE'
3855: AND AWCV.ITEM_INSTANCE_ID = c_instance_id
3856: AND AWCV.WARRANTY_TEMPLATE_ID = c_warranty_templ_id;
3857: