DBA Data[Home] [Help]

APPS.AHL_PRD_WORKORDER_PVT dependencies on AHL_WARRANTY_CONTRACTS_B

Line 11977: FROM AHL_WARRANTY_CONTRACTS_B AWCB,

11973: l_debug_module CONSTANT VARCHAR2(100) := 'ahl.plsql.AHL_PRD_WORKORDER_PVT.POPULATE_ENTITLEMENTS';
11974:
11975: CURSOR get_contract_id ( c_contract_number NUMBER, c_visit_task_id NUMBER) IS
11976: SELECT WARRANTY_CONTRACT_ID
11977: FROM AHL_WARRANTY_CONTRACTS_B AWCB,
11978: AHL_VISITS_B VST,
11979: AHL_VISIT_TASKS_B VTS
11980: WHERE VTS.VISIT_TASK_ID = c_visit_task_id
11981: AND VTS.VISIT_ID = VST.VISIT_ID