APPS.PO_PCARD_PKG dependencies on AP_CARDS

Line 15: from ap_cards ac

11: begin
12: begin
13: select 1
14: into x_valid
15: from ap_cards ac
16: where ac.card_id = x_pcard_id
17: and (card_expiration_date is null or
18: card_expiration_date >= trunc(sysdate)) --
19: and (INACTIVE_DATE is null or

Line 98: FROM ap_cards_all ac

94: --
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 )