APPS.AP_WEB_DB_AP_INT_PKG dependencies on AP_CREDIT_CARD_TRXNS

Line 1370: l_transaction_date ap_credit_card_trxns.transaction_date%type;

1366: ) RETURN NUMBER IS
1367: -------------------------------------------------------------------
1368: l_employee_id number;
1369: l_card_program_id number;
1370: l_transaction_date ap_credit_card_trxns.transaction_date%type;
1371: l_ccid ap_expense_report_headers_all.employee_ccid%type;
1372: BEGIN
1373:
1374: SELECT employee_id, txn.card_program_id, transaction_date

Line 1377: ap_credit_card_trxns txn

1373:
1374: SELECT employee_id, txn.card_program_id, transaction_date
1375: INTO l_employee_id, l_card_program_id, l_transaction_date
1376: FROM ap_cards card,
1377: ap_credit_card_trxns txn
1378: WHERE card.card_program_id = txn.card_program_id
1379: AND card.card_id = txn.card_id
1380: AND txn.trx_id = p_trx_id;
1381: