APPS.OKE_ACTION_VALIDATIONS_PKG dependencies on OKE_DELIVERABLE_ACTIONS

Line 98: FROM oke_deliverable_actions

94: L_Number VARCHAR2(120);
95:
96: CURSOR c IS
97: SELECT pa_action_id
98: FROM oke_deliverable_actions
99: WHERE action_id = p_action_id;
100:
101: BEGIN
102: OPEN c;

Line 156: FROM oke_deliverable_actions b

152: AND NVL(shippable_item_flag, 'N') = 'Y';
153:
154: CURSOR c3 IS
155: SELECT '!'
156: FROM oke_deliverable_actions b
157: WHERE b.Action_ID = p_Action_ID
158: AND (b.deliverable_id = p_deliverable_id or b.deliverable_id is null and p_deliverable_id is null)
159: AND (b.Task_ID = p_Task_ID or b.Task_ID is null and p_Task_ID is null)
160: AND (b.Ship_From_Org_ID = p_Ship_From_Org_ID or b.Ship_From_Org_ID is null and p_Ship_From_Org_ID is null)

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' ;