APPS.AP_WEB_EXPENSE_WF dependencies on AP_CREDIT_CARD_TRXNS

Line 2008: l_transaction_date ap_credit_card_trxns_all.transaction_date%type;

2004: l_existing_segments AP_OIE_KFF_SEGMENTS_T;
2005: l_new_segments AP_OIE_KFF_SEGMENTS_T;
2006: l_dist_new_segments AP_OIE_KFF_SEGMENTS_T;
2007:
2008: l_transaction_date ap_credit_card_trxns_all.transaction_date%type;
2009:
2010: BEGIN
2011:
2012: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start DoAPValidation');

Line 2242: FROM ap_credit_card_trxns

2238: IF (l_payment_due = C_CompanyPay AND l_exp_type_parameter_id = l_personalParameterId) THEN
2239:
2240: SELECT card_program_id, transaction_date
2241: INTO l_card_program_id, l_transaction_date
2242: FROM ap_credit_card_trxns
2243: WHERE trx_id = V_CreditCardTrxID;
2244:
2245: IF (NOT AP_WEB_DB_AP_INT_PKG.GetExpenseClearingCCID(p_ccid => l_exp_dist_ccid,
2246: p_card_program_id => l_card_program_id,

Line 2333: FROM ap_credit_card_trxns

2329: IF (l_payment_due = C_CompanyPay AND l_exp_type_parameter_id = l_personalParameterId) THEN
2330:
2331: SELECT card_program_id, transaction_date
2332: INTO l_card_program_id, l_transaction_Date
2333: FROM ap_credit_card_trxns
2334: WHERE trx_id = V_CreditCardTrxID;
2335:
2336: IF (NOT AP_WEB_DB_AP_INT_PKG.GetExpenseClearingCCID(p_ccid => l_exp_dist_ccid,
2337: p_card_program_id => l_card_program_id,

Line 12039: l_cc_merchant_name AP_CREDIT_CARD_TRXNS_ALL.merchant_name1%TYPE;--Bug 2944363

12035: l_payment VARCHAR2(10);--Bug 2944363
12036: l_cc_trxn_date VARCHAR2(50);--Bug 2944363
12037: l_cc_expensed_amt AP_WEB_DB_EXPLINE_PKG.expLines_amount;--Bug 2944363
12038: l_cc_curr_code VARCHAR2(20); --Bug 2944363
12039: l_cc_merchant_name AP_CREDIT_CARD_TRXNS_ALL.merchant_name1%TYPE;--Bug 2944363
12040: l_payment_due_from VARCHAR2(10) := 'INDIVIDUAL';
12041:
12042: BEGIN
12043: