DBA Data[Home] [Help]

APPS.CSD_WARRANTY_CONTRACT_PVT dependencies on AHL_WARRANTY_CONTRACTS_B

Line 218: FROM AHL_WARRANTY_CONTRACTS_B contract

214:
215: CURSOR C2_get_contract_count(p_instance_id number)
216: IS
217: SELECT count(contract.warranty_contract_id)
218: FROM AHL_WARRANTY_CONTRACTS_B contract
219: WHERE contract.contract_status_code = 'ACTIVE'
220: AND TRUNC(NVL(contract.expiration_date, SYSDATE + 1)) > TRUNC(sysdate)
221: AND contract.item_instance_id = p_instance_id;
222:

Line 226: FROM AHL_WARRANTY_CONTRACTS_B contract

222:
223: CURSOR C3_get_w_contract_id(p_instance_id number)
224: IS
225: SELECT contract.warranty_contract_id
226: FROM AHL_WARRANTY_CONTRACTS_B contract
227: WHERE contract.contract_status_code = 'ACTIVE'
228: AND TRUNC(NVL(contract.expiration_date, SYSDATE + 1)) > TRUNC(sysdate)
229: AND contract.item_instance_id = p_instance_id;
230: