APPS.PO_KANBAN_SV dependencies on PO_DISTRIBUTIONS

Line 23: FROM PO_DISTRIBUTIONS

19:
20: -- Define cursor for getting release Kanban Card ID
21: CURSOR Kanban_rel_dist IS
22: SELECT PO_DISTRIBUTION_ID, KANBAN_CARD_ID
23: FROM PO_DISTRIBUTIONS
24: WHERE PO_RELEASE_ID = p_document_id
25: AND KANBAN_CARD_ID is not NULL;
26:
27: -- Define cursor for getting PO Kanban Card ID

Line 30: FROM PO_DISTRIBUTIONS

26:
27: -- Define cursor for getting PO Kanban Card ID
28: CURSOR Kanban_PO_dist IS
29: SELECT PO_DISTRIBUTION_ID, KANBAN_CARD_ID
30: FROM PO_DISTRIBUTIONS
31: WHERE PO_HEADER_ID = p_document_id
32: AND KANBAN_CARD_ID is not NULL;
33:
34: -- Define cursor for getting PO Kanban Card ID

Line 59: -- Update PO distributions kanban card status

55:
56:
57: IF p_document_type = 'PO' THEN
58:
59: -- Update PO distributions kanban card status
60:
61: OPEN Kanban_PO_dist;
62:
63: LOOP