APPS.AP_WEB_EXPENSE_WF dependencies on AP_CREDIT_CARD_TRXNS

Line 1991: l_transaction_date ap_credit_card_trxns_all.transaction_date%type;

1987: l_existing_segments AP_OIE_KFF_SEGMENTS_T;
1988: l_new_segments AP_OIE_KFF_SEGMENTS_T;
1989: l_dist_new_segments AP_OIE_KFF_SEGMENTS_T;
1990:
1991: l_transaction_date ap_credit_card_trxns_all.transaction_date%type;
1992:
1993: BEGIN
1994:
1995: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start DoAPValidation');

Line 2225: FROM ap_credit_card_trxns

2221: IF (l_payment_due = C_CompanyPay AND l_exp_type_parameter_id = l_personalParameterId) THEN
2222:
2223: SELECT card_program_id, transaction_date
2224: INTO l_card_program_id, l_transaction_date
2225: FROM ap_credit_card_trxns
2226: WHERE trx_id = V_CreditCardTrxID;
2227:
2228: IF (NOT AP_WEB_DB_AP_INT_PKG.GetExpenseClearingCCID(p_ccid => l_exp_dist_ccid,
2229: p_card_program_id => l_card_program_id,

Line 2316: FROM ap_credit_card_trxns

2312: IF (l_payment_due = C_CompanyPay AND l_exp_type_parameter_id = l_personalParameterId) THEN
2313:
2314: SELECT card_program_id, transaction_date
2315: INTO l_card_program_id, l_transaction_Date
2316: FROM ap_credit_card_trxns
2317: WHERE trx_id = V_CreditCardTrxID;
2318:
2319: IF (NOT AP_WEB_DB_AP_INT_PKG.GetExpenseClearingCCID(p_ccid => l_exp_dist_ccid,
2320: p_card_program_id => l_card_program_id,

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

11272: l_payment VARCHAR2(10);--Bug 2944363
11273: l_cc_trxn_date VARCHAR2(50);--Bug 2944363
11274: l_cc_expensed_amt AP_WEB_DB_EXPLINE_PKG.expLines_amount;--Bug 2944363
11275: l_cc_curr_code VARCHAR2(20); --Bug 2944363
11276: l_cc_merchant_name AP_CREDIT_CARD_TRXNS_ALL.merchant_name1%TYPE;--Bug 2944363
11277: l_payment_due_from VARCHAR2(10) := 'INDIVIDUAL';
11278:
11279: BEGIN
11280: