APPS.OKE_ACTION_VALIDATIONS_PKG dependencies on OKE_DELIVERABLES_B

Line 144: FROM oke_deliverables_b b

140: , b.inventory_org_id
141: , b.quantity
142: , b.uom_code
143: , b.project_id
144: FROM oke_deliverables_b b
145: WHERE b.deliverable_id = p_deliverable_id;
146:
147: CURSOR c2 IS
148: SELECT '!'

Line 283: FROM oke_deliverables_b b

279: SELECT b.item_id
280: , b.inventory_org_id
281: , b.source_deliverable_id
282: , b.project_id, 'x'
283: FROM oke_deliverables_b b
284: WHERE b.deliverable_id = p_deliverable_id
285: AND b.source_code = 'PA';
286:
287: CURSOR c2 IS

Line 453: FROM oke_deliverables_b b , oke_deliverable_actions act

449: SELECT b.item_id ,
450: nvl(b.inventory_org_id,act.ship_to_org_id) org_id ,
451: b.project_id ,
452: b.source_deliverable_id, 'x'
453: FROM oke_deliverables_b b , oke_deliverable_actions act
454: WHERE b.deliverable_id = P_Deliverable_ID
455: and b.deliverable_id = act.Deliverable_ID
456: and act.action_id = p_action_id
457: AND b.source_code = 'PA' ;