DBA Data[Home] [Help]

APPS.AHL_PRD_PARTS_CHANGE_PVT dependencies on AHL_CMP_UTIL_PKG

Line 145: AND AHL_CMP_UTIL_PKG.Is_Comp_Visit(TSK.visit_id) = 'Y';

141: SELECT 'X'
142: FROM AHL_WORKORDERS WO, AHL_VISIT_TASKS_B TSK
143: WHERE WO.workorder_id = c_workorder_id
144: AND TSK.visit_task_id = WO.visit_task_id
145: AND AHL_CMP_UTIL_PKG.Is_Comp_Visit(TSK.visit_id) = 'Y';
146:
147: l_api_name CONSTANT VARCHAR2(30) := 'Process_Part_Change';
148: l_api_version CONSTANT NUMBER := 1.0;
149: l_msg_count number;