DBA Data[Home] [Help]

APPS.AP_WEB_DB_AP_INT_PKG dependencies on AP_CREDIT_CARD_TRXNS

Line 1412: l_transaction_date ap_credit_card_trxns.transaction_date%type;

1408: ) RETURN NUMBER IS
1409: -------------------------------------------------------------------
1410: l_employee_id number;
1411: l_card_program_id number;
1412: l_transaction_date ap_credit_card_trxns.transaction_date%type;
1413: l_ccid ap_expense_report_headers_all.employee_ccid%type;
1414: BEGIN
1415:
1416: SELECT employee_id, txn.card_program_id, transaction_date

Line 1419: ap_credit_card_trxns txn

1415:
1416: SELECT employee_id, txn.card_program_id, transaction_date
1417: INTO l_employee_id, l_card_program_id, l_transaction_date
1418: FROM ap_cards card,
1419: ap_credit_card_trxns txn
1420: WHERE card.card_program_id = txn.card_program_id
1421: AND card.card_id = txn.card_id
1422: AND txn.trx_id = p_trx_id;
1423: