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 235: DELETE FROM wip_period_balances

231: close check_repetitive_charges;
232:
233: END IF; -- end ent_type
234:
235: DELETE FROM wip_period_balances
236: WHERE wip_entity_id = x_wip_id
237: AND NVL(repetitive_schedule_id, -1) =
238: NVL(x_rep_id, -1)
239: AND organization_id = x_org_id;

Line 361: FROM wip_period_balances

357: L_PL_MATERIAL_OVERHEAD_OUT ,
358: L_PL_RESOURCE_OUT ,
359: L_PL_OVERHEAD_OUT ,
360: L_PL_OUTSIDE_PROCESSING_OUT
361: FROM wip_period_balances
362: WHERE wip_entity_id = x_wip_id
363: AND organization_id=x_org_id
364: AND nvl(repetitive_schedule_id , -1) = nvl(x_rep_id, -1);
365: