APPS.AHL_WARRANTY_ENTL_PVT dependencies on AHL_WARRANTY_CONTRACTS_B

Line 1577: FROM AHL_WARRANTY_CONTRACTS_B

1573: WHERE warranty_entitlement_id = c_warranty_entl_id;
1574:
1575: CURSOR chk_war_cont_id_csr (c_contract_id NUMBER) IS
1576: SELECT 'X'
1577: FROM AHL_WARRANTY_CONTRACTS_B
1578: WHERE warranty_contract_id = c_contract_id
1579: AND contract_status_code = 'ACTIVE';
1580:
1581: --

Line 1735: FROM AHL_WARRANTY_CONTRACTS_B

1731: ) IS
1732:
1733: CURSOR chk_war_cont_id_csr (c_contract_id NUMBER) IS
1734: SELECT 'X'
1735: FROM AHL_WARRANTY_CONTRACTS_B
1736: WHERE warranty_contract_id = c_contract_id
1737: AND contract_status_code = 'ACTIVE';
1738:
1739: CURSOR chk_entl_sts_code_csr (c_entl_sts_code VARCHAR2) IS