APPS.WIP_SF_STATUS dependencies on WIP_DISCRETE_JOBS

Line 53: FROM WIP_DISCRETE_JOBS wdj

49: AND NVL(LINE_ID, -1) = NVL(P_line_id, -1)
50: AND INTRAOPERATION_STEP_TYPE = P_intraoperation_step_type)
51: AND (EXISTS(
52: SELECT 'job_exists'
53: FROM WIP_DISCRETE_JOBS wdj
54: WHERE wdj.wip_entity_id = P_wip_entity_id
55: AND wdj.organization_id = P_organization_id)
56: OR EXISTS(
57: SELECT 'schedule exists'

Line 98: FROM WIP_DISCRETE_JOBS

94: X_return_value BOOLEAN := TRUE;
95:
96: CURSOR disc_info IS
97: SELECT 'is there a valid job'
98: FROM WIP_DISCRETE_JOBS
99: WHERE WIP_ENTITY_ID = P_wip_entity_id
100: AND ORGANIZATION_ID = P_organization_id
101: AND STATUS_TYPE IN (WIP_CONSTANTS.UNRELEASED, WIP_CONSTANTS.RELEASED,
102: WIP_CONSTANTS.COMP_CHRG, WIP_CONSTANTS.HOLD);