APPS.AR_INVOICE_UTILS dependencies on AR_RECEIPT_CLASSES

Line 317: ar_receipt_classes rc

313: WHERE gt.payment_trxn_extension_id IS NOT NULL
314: AND EXISTS
315: (SELECT 'X'
316: FROM ar_receipt_methods rm,
317: ar_receipt_classes rc
318: WHERE rm.receipt_method_id = gt.receipt_method_id
319: AND rm.receipt_class_id = rc.receipt_class_id
320: AND rc.creation_method_code = 'MANUAL' );
321:

Line 352: ar_receipt_classes rc

348: AND gt.payment_trxn_extension_id IS NULL
349: AND EXISTS
350: (SELECT 'X'
351: FROM ar_receipt_methods rm,
352: ar_receipt_classes rc
353: WHERE rm.receipt_method_id = gt.receipt_method_id
354: AND rm.receipt_class_id = rc.receipt_class_id
355: AND rc.creation_method_code = 'AUTOMATIC' );
356:

Line 1103: ar_receipt_classes rc

1099: WHERE gt.customer_bank_account_id IS NOT NULL
1100: AND NOT EXISTS (
1101: SELECT 'X'
1102: FROM ar_receipt_methods rm,
1103: ar_receipt_classes rc
1104: WHERE rm.receipt_class_id = rc.receipt_class_id
1105: AND rm.receipt_method_id = gt.receipt_method_id
1106: AND rc.creation_method_code = 'AUTOMATIC');
1107:

Line 6138: l_creation_method_code ar_receipt_classes.creation_method_code%type;

6134: WHERE receipt_method_id IS NULL;
6135: --AND payment_trxn_extension_id IS NOT NULL;
6136: l_receipt_method_name ar_receipt_methods.name%type;
6137: l_receipt_method_id ar_receipt_methods.receipt_method_id%type;
6138: l_creation_method_code ar_receipt_classes.creation_method_code%type;
6139: l_bank_account_id ce_bank_accounts.bank_account_id%type;
6140: l_bank_account_num ce_bank_accounts.bank_account_num%type;
6141: l_bank_name ce_bank_branches_v.bank_name%type;
6142: l_bank_branch_name ce_bank_branches_v.bank_branch_name%type;

Line 6205: l_creation_method_code ar_receipt_classes.creation_method_code%type;

6201: AND payment_trxn_extension_id IS NULL;
6202:
6203: l_receipt_method_name ar_receipt_methods.name%type;
6204: l_receipt_method_id ar_receipt_methods.receipt_method_id%type;
6205: l_creation_method_code ar_receipt_classes.creation_method_code%type;
6206: l_bank_account_id ce_bank_accounts.bank_account_id%type;
6207: l_bank_account_num ce_bank_accounts.bank_account_num%type;
6208: l_bank_name ce_bank_branches_v.bank_name%type;
6209: l_bank_branch_name ce_bank_branches_v.bank_branch_name%type;