APPS.AP_WEB_AUDIT_UTILS dependencies on AP_CREDIT_CARD_TRXNS_ALL

Line 2308: ap_credit_card_trxns_all cct

2304:
2305: CURSOR program_c IS
2306: SELECT cp.org_id, cp.expense_clearing_ccid
2307: FROM ap_card_programs_all cp,
2308: ap_credit_card_trxns_all cct
2309: WHERE cp.card_program_id = cct.card_program_id
2310: AND cct.trx_id = p_trx_id;
2311:
2312: CURSOR ccid_c(p_org_id IN NUMBER) IS

Line 2369: FROM ap_credit_card_trxns_all cct

2365: *=======================================================================*/
2366: FUNCTION get_payment_due_from(p_trx_id IN NUMBER) RETURN VARCHAR2 IS
2367: CURSOR trx_c IS
2368: SELECT cct.payment_due_from_code
2369: FROM ap_credit_card_trxns_all cct
2370: WHERE cct.trx_id = p_trx_id;
2371:
2372: lv_payment_due_from_prof VARCHAR2(100);
2373: lv_payment_due_from VARCHAR2(100);

Line 3243: from ap_credit_card_trxns_all

3239: FUNCTION has_default_cc_itemization(p_cc_trx_id IN NUMBER) RETURN VARCHAR2 IS
3240:
3241: CURSOR cc_trx IS
3242: select nvl(trxn_detail_flag, 'N') as trxn_detail_flag
3243: from ap_credit_card_trxns_all
3244: where trx_id = p_cc_trx_id;
3245:
3246: l_trx_detail_flag VARCHAR2(1);
3247: