APPS.WIP_SF_STATUS dependencies on WIP_PARAMETERS

Line 183: from wip_parameters wp

179: l_osp_shop_floor_status VARCHAR2(10);
180:
181: cursor get_status (c_org_id number) is
182: select osp_shop_floor_status
183: from wip_parameters wp
184: where wp.organization_id = c_org_id;
185: BEGIN
186: OPEN get_status (p_org_id);
187: FETCH get_status into l_osp_shop_floor_status;

Line 308: WIP_PARAMETERS WP,

304: SELECT COUNT(1)
305: INTO x_no_move_count
306: FROM WIP_OPERATIONS WOP,
307: WIP_OPERATION_RESOURCES WOR,
308: WIP_PARAMETERS WP,
309: WIP_SHOP_FLOOR_STATUS_CODES WSFSC,
310: WIP_SHOP_FLOOR_STATUSES WSFS
311: WHERE WSFS.INTRAOPERATION_STEP_TYPE IN (1,/* Queue */
312: 2,/* Run */