APPS.PO_PCARD_PKG dependencies on PO_SESSION_GT

Line 81: INSERT INTO po_session_gt

77:
78: l_key := PO_CORE_S.get_session_gt_nextval;
79:
80: FORALL i IN 1..p_pcard_id_tbl.COUNT
81: INSERT INTO po_session_gt
82: ( key
83: , index_num1
84: )
85: VALUES

Line 99: , po_session_gt gt

95: SELECT ac.card_id
96: BULK COLLECT
97: INTO l_valid_pcard_id_tbl
98: FROM ap_cards_all ac
99: , po_session_gt gt
100: WHERE ac.card_id = gt.index_num1 -- select only P-cards in GT table
101: AND gt.key = l_key -- which we inserted above
102: AND ( ( ac.card_expiration_date IS NULL )
103: OR ( ac.card_expiration_date >= trunc(sysdate) ) )

Line 119: DELETE FROM po_session_gt gt

115: -- Clean Up GT Table ------------------------------------------------------
116:
117: -- Delete all records that we inserted into the GT table.
118: --
119: DELETE FROM po_session_gt gt
120: WHERE gt.key = l_key;
121:
122:
123: -- Filter Results ---------------------------------------------------------