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 1096: ar_receipt_classes rc

1092: WHERE gt.customer_bank_account_id IS NOT NULL
1093: AND NOT EXISTS (
1094: SELECT 'X'
1095: FROM ar_receipt_methods rm,
1096: ar_receipt_classes rc
1097: WHERE rm.receipt_class_id = rc.receipt_class_id
1098: AND rm.receipt_method_id = gt.receipt_method_id
1099: AND rc.creation_method_code = 'AUTOMATIC');
1100:

Line 6010: l_creation_method_code ar_receipt_classes.creation_method_code%type;

6006: WHERE receipt_method_id IS NULL
6007: AND payment_trxn_extension_id IS NOT NULL;
6008: l_receipt_method_name ar_receipt_methods.name%type;
6009: l_receipt_method_id ar_receipt_methods.receipt_method_id%type;
6010: l_creation_method_code ar_receipt_classes.creation_method_code%type;
6011: l_bank_account_id ce_bank_accounts.bank_account_id%type;
6012: l_bank_account_num ce_bank_accounts.bank_account_num%type;
6013: l_bank_name ce_bank_branches_v.bank_name%type;
6014: l_bank_branch_name ce_bank_branches_v.bank_branch_name%type;