APPS.WIP_UNRELEASE dependencies on WIP_PERIOD_BALANCES

Line 16: FROM WIP_DISCRETE_JOBS DJ, WIP_PERIOD_BALANCES WPB

12: po_req_exist VARCHAR2(20);
13:
14: cursor check_discrete_charges is
15: SELECT DISTINCT 'X'
16: FROM WIP_DISCRETE_JOBS DJ, WIP_PERIOD_BALANCES WPB
17: WHERE DJ.WIP_ENTITY_ID = WPB.WIP_ENTITY_ID
18: AND DJ.ORGANIZATION_ID = WPB.ORGANIZATION_ID
19: AND DJ.WIP_ENTITY_ID = x_wip_id
20: AND DJ.ORGANIZATION_ID = x_org_id

Line 85: FROM WIP_REPETITIVE_SCHEDULES RS, WIP_PERIOD_BALANCES WPB

81: AND WIP_ENTITY_ID = x_wip_id) WHERE Result = 'X' ));
82:
83: cursor check_repetitive_charges is
84: SELECT 'X'
85: FROM WIP_REPETITIVE_SCHEDULES RS, WIP_PERIOD_BALANCES WPB
86: WHERE RS.WIP_ENTITY_ID = WPB.WIP_ENTITY_ID
87: AND RS.ORGANIZATION_ID = WPB.ORGANIZATION_ID
88: AND RS.REPETITIVE_SCHEDULE_ID =
89: WPB.REPETITIVE_SCHEDULE_ID

Line 218: DELETE FROM wip_period_balances

214: close check_repetitive_charges;
215:
216: END IF; -- end ent_type
217:
218: DELETE FROM wip_period_balances
219: WHERE wip_entity_id = x_wip_id
220: AND NVL(repetitive_schedule_id, -1) =
221: NVL(x_rep_id, -1)
222: AND organization_id = x_org_id;

Line 315: FROM wip_period_balances

311: L_PL_MATERIAL_OVERHEAD_OUT ,
312: L_PL_RESOURCE_OUT ,
313: L_PL_OVERHEAD_OUT ,
314: L_PL_OUTSIDE_PROCESSING_OUT
315: FROM wip_period_balances
316: WHERE wip_entity_id = x_wip_id
317: AND organization_id=x_org_id
318: AND nvl(repetitive_schedule_id , -1) = nvl(x_rep_id, -1);
319: