APPS.ARP_CORRECT_CC_ERRORS dependencies on IBY_TRXN_EXTENSIONS_V

Line 606: iby_trxn_extensions_v iby,

602: ar_receipt_methods rm,
603: hz_parties party,
604: hz_cust_accounts cust,
605: hz_cust_site_uses site_uses,
606: iby_trxn_extensions_v iby,
607: iby_fndcpt_pmt_chnnls_b pc
608: WHERE trx.receipt_method_id = rm.receipt_method_id
609: AND rm.payment_channel_code = pc.payment_channel_code
610: AND pc.instrument_type = 'CREDITCARD'

Line 1982: | errored credit card in iby_trxn_extensions_v

1978: | ARGUMENTS : IN:
1979: | p_cc_trx_id - Cash_receipt_id/Customer_trx_id
1980: | p_cc_trx_category - RECEIPT/INVOICE/REFUND
1981: | p_payment_trxn_extension_id - This is the id correpsonding to
1982: | errored credit card in iby_trxn_extensions_v
1983: | p_error_notes - Error notes to be attached
1984: | OUT:
1985: |
1986: | RETURNS : NONE

Line 2067: | errored credit card in iby_trxn_extensions_v

2063: | ARGUMENTS : IN:
2064: | p_cc_trx_id - Cash_receipt_id/Customer_trx_id
2065: | p_cc_trx_category - RECEIPT/INVOICE/REFUND
2066: | p_payment_trxn_extension_id - This is the id correpsonding to
2067: | errored credit card in iby_trxn_extensions_v
2068: | p_error_notes - Error notes to be attached
2069: | OUT:
2070: |
2071: | RETURNS : NONE

Line 2381: iby_trxn_extensions_v iby

2377: ar_receipt_methods rm,
2378: hz_parties party,
2379: hz_cust_accounts cust,
2380: hz_cust_site_uses site_uses,
2381: iby_trxn_extensions_v iby
2382: WHERE rm.receipt_method_id = cr.receipt_method_id
2383: AND cr.pay_from_customer = cust.cust_account_id (+)
2384: AND cust.party_id = party.party_id (+)
2385: AND cr.customer_site_use_id = site_uses.site_use_id (+)