DBA Data[Home] [Help]

APPS.ARP_TRX_DEFAULTS_3 dependencies on AR_RECEIPT_CLASSES

Line 483: ar_receipt_classes.creation_method_code%type

479: ar_receipt_methods.name%type,
480: p_receipt_method_id OUT NOCOPY
481: ar_receipt_methods.receipt_method_id%type,
482: p_creation_method_code OUT NOCOPY
483: ar_receipt_classes.creation_method_code%type
484: ) RETURN BOOLEAN IS
485:
486: CURSOR payment_method_cur IS
487: SELECT arm.name payment_method_name,

Line 496: ar_receipt_classes arc,

492: ra_cust_receipt_methods rcrm,
493: ar_receipt_method_accounts arma,
494: ce_bank_acct_uses_all aba,
495: ce_bank_accounts cba,
496: ar_receipt_classes arc,
497: ce_bank_branches_v bp /*Bug3348454*/
498: WHERE arm.receipt_method_id = rcrm.receipt_method_id
499: AND arm.receipt_method_id = arma.receipt_method_id
500: AND arm.receipt_class_id = arc.receipt_class_id

Line 571: ar_receipt_classes arc,

567: arm.payment_channel_code,
568: arc.creation_method_code
569: FROM ar_receipt_methods arm,
570: ra_cust_receipt_methods rcrm,
571: ar_receipt_classes arc,
572: ar_system_parameters sys
573: WHERE arm.receipt_method_id = rcrm.receipt_method_id
574: AND arm.receipt_class_id = arc.receipt_class_id
575: AND arc.creation_method_code = 'BR'

Line 606: l_creation_method_code ar_receipt_classes.creation_method_code%type;

602: p_trx_date));
603:
604: l_payment_method_name ar_receipt_methods.name%type;
605: l_receipt_method_id ar_receipt_methods.receipt_method_id%type;
606: l_creation_method_code ar_receipt_classes.creation_method_code%type;
607: payment_method_rec payment_method_cur%ROWTYPE;
608:
609: BEGIN
610:

Line 800: ar_receipt_classes.creation_method_code%type,

796: ar_receipt_methods.name%type,
797: p_receipt_method_id OUT NOCOPY
798: ar_receipt_methods.receipt_method_id%type,
799: p_creation_method_code OUT NOCOPY
800: ar_receipt_classes.creation_method_code%type,
801: p_trx_manual_flag IN VARCHAR2 DEFAULT 'N'
802: ) IS
803:
804:

Line 1257: ar_receipt_classes.creation_method_code%type,

1253: ar_receipt_methods.name%type,
1254: p_receipt_method_id OUT NOCOPY
1255: ar_receipt_methods.receipt_method_id%type,
1256: p_creation_method_code OUT NOCOPY
1257: ar_receipt_classes.creation_method_code%type,
1258: p_customer_bank_account_id OUT NOCOPY
1259: ce_bank_accounts.bank_account_id%type,
1260: p_bank_account_num OUT NOCOPY
1261: ce_bank_accounts.bank_account_num%type,