APPS.AP_WEB_AUDIT_UTILS dependencies on AP_CREDIT_CARD_TRXNS_ALL

Line 2266: ap_credit_card_trxns_all cct

2262:
2263: CURSOR program_c IS
2264: SELECT cp.org_id, cp.expense_clearing_ccid
2265: FROM ap_card_programs_all cp,
2266: ap_credit_card_trxns_all cct
2267: WHERE cp.card_program_id = cct.card_program_id
2268: AND cct.trx_id = p_trx_id;
2269:
2270: CURSOR ccid_c(p_org_id IN NUMBER) IS

Line 2327: FROM ap_credit_card_trxns_all cct

2323: *=======================================================================*/
2324: FUNCTION get_payment_due_from(p_trx_id IN NUMBER) RETURN VARCHAR2 IS
2325: CURSOR trx_c IS
2326: SELECT cct.payment_due_from_code
2327: FROM ap_credit_card_trxns_all cct
2328: WHERE cct.trx_id = p_trx_id;
2329:
2330: lv_payment_due_from_prof VARCHAR2(100);
2331: lv_payment_due_from VARCHAR2(100);

Line 3194: from ap_credit_card_trxns_all

3190: FUNCTION has_default_cc_itemization(p_cc_trx_id IN NUMBER) RETURN VARCHAR2 IS
3191:
3192: CURSOR cc_trx IS
3193: select nvl(trxn_detail_flag, 'N') as trxn_detail_flag
3194: from ap_credit_card_trxns_all
3195: where trx_id = p_cc_trx_id;
3196:
3197: l_trx_detail_flag VARCHAR2(1);
3198: