DBA Data[Home] [Help]

APPS.AR_AUTOREM_API dependencies on AR_RECEIPT_CLASSES

Line 97: l_remittance_method ar_receipt_classes.remit_method_code%TYPE;

93: l_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;
94: l_format_flag ar_cash_receipts.confirmed_flag%TYPE ;
95: l_create_flag ar_cash_receipts.confirmed_flag%TYPE ;
96: l_currency_code ar_cash_receipts.currency_code%TYPE;
97: l_remittance_method ar_receipt_classes.remit_method_code%TYPE;
98: l_receipt_class_id ar_receipt_classes.receipt_class_id%TYPE ;
99: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE ;
100: l_remittance_bank_branch_id ap_bank_accounts.bank_branch_id%TYPE DEFAULT NULL;
101: l_remittance_bank_account_id ar_receipt_method_accounts.REMIT_BANK_ACCT_USE_ID%TYPE DEFAULT NULL;

Line 98: l_receipt_class_id ar_receipt_classes.receipt_class_id%TYPE ;

94: l_format_flag ar_cash_receipts.confirmed_flag%TYPE ;
95: l_create_flag ar_cash_receipts.confirmed_flag%TYPE ;
96: l_currency_code ar_cash_receipts.currency_code%TYPE;
97: l_remittance_method ar_receipt_classes.remit_method_code%TYPE;
98: l_receipt_class_id ar_receipt_classes.receipt_class_id%TYPE ;
99: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE ;
100: l_remittance_bank_branch_id ap_bank_accounts.bank_branch_id%TYPE DEFAULT NULL;
101: l_remittance_bank_account_id ar_receipt_method_accounts.REMIT_BANK_ACCT_USE_ID%TYPE DEFAULT NULL;
102: o_batch_id NUMBER;

Line 941: l_remittance_method ar_receipt_classes.remit_method_code%TYPE;

937: l_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;
938: l_format_flag ar_cash_receipts.confirmed_flag%TYPE ;
939: l_create_flag ar_cash_receipts.confirmed_flag%TYPE ;
940: l_currency_code ar_cash_receipts.currency_code%TYPE;
941: l_remittance_method ar_receipt_classes.remit_method_code%TYPE;
942: l_receipt_class_id ar_receipt_classes.receipt_class_id%TYPE ;
943: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE ;
944: l_remittance_bank_branch_id ap_bank_accounts.bank_branch_id%TYPE DEFAULT NULL;
945: l_remittance_bank_account_id ar_receipt_method_accounts.REMIT_BANK_ACCT_USE_ID%TYPE DEFAULT NULL;

Line 942: l_receipt_class_id ar_receipt_classes.receipt_class_id%TYPE ;

938: l_format_flag ar_cash_receipts.confirmed_flag%TYPE ;
939: l_create_flag ar_cash_receipts.confirmed_flag%TYPE ;
940: l_currency_code ar_cash_receipts.currency_code%TYPE;
941: l_remittance_method ar_receipt_classes.remit_method_code%TYPE;
942: l_receipt_class_id ar_receipt_classes.receipt_class_id%TYPE ;
943: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE ;
944: l_remittance_bank_branch_id ap_bank_accounts.bank_branch_id%TYPE DEFAULT NULL;
945: l_remittance_bank_account_id ar_receipt_method_accounts.REMIT_BANK_ACCT_USE_ID%TYPE DEFAULT NULL;
946: l_batch_applied_status ar_batches.batch_applied_status%TYPE;

Line 1269: ar_receipt_classes rc,

1265: MOD(CEIL((DENSE_RANK() over(order by crh.cash_receipt_id))/5000), :b_total_workers) + 1
1266: FROM ar_rem_cr_id_gtt gtt,
1267: ar_cash_receipts cr,
1268: ar_receipt_methods rm,
1269: ar_receipt_classes rc,
1270: hz_cust_accounts hca,
1271: hz_parties party,
1272: /*ar_remit_gt g,*/
1273: ar_cash_receipt_history crh,

Line 1445: p_receipt_class_id IN ar_receipt_classes.receipt_class_id%TYPE,

1441: p_approve_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
1442: p_format_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
1443: p_currency_code IN ar_batches.currency_code%TYPE,
1444: p_remmitance_method IN ar_batches.remit_method_code%TYPE,
1445: p_receipt_class_id IN ar_receipt_classes.receipt_class_id%TYPE,
1446: p_payment_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
1447: p_remmitance_bank_branch_id IN ap_bank_accounts.bank_branch_id%TYPE DEFAULT NULL,
1448: p_remmitance_bank_account_id IN ar_receipt_method_accounts.REMIT_BANK_ACCT_USE_ID%TYPE DEFAULT NULL,
1449: p_batch_id OUT NOCOPY NUMBER

Line 3295: p_remit_method_code IN ar_receipt_classes.remit_method_code%TYPE,

3291: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
3292: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
3293: p_payment_type_code IN ar_receipt_methods.payment_type_code%TYPE,
3294: p_sob_id IN ar_cash_receipts.set_of_books_id%TYPE,
3295: p_remit_method_code IN ar_receipt_classes.remit_method_code%TYPE,
3296: p_remit_bank_account_id IN ar_cash_receipts.remittance_bank_account_id%TYPE,
3297: p_return_status OUT NOCOPY VARCHAR2
3298: ) IS
3299:

Line 3386: ar_receipt_classes rclass,

3382: FROM ar_rem_cr_id_gtt crh,
3383: ar_cash_receipt_history crh1,
3384: ar_cash_receipts cr,
3385: ar_payment_schedules ps,
3386: ar_receipt_classes rclass,
3387: ar_receipt_methods rm,
3388: ar_receipt_method_accounts rma1,
3389: ar_receipt_method_accounts rma2
3390: WHERE crh1.status = ''CONFIRMED''

Line 3644: ar_receipt_classes rc,

3640: cr.selected_remittance_batch_id,
3641: cr.receipt_date
3642: FROM ar_cash_receipts cr,
3643: ar_receipt_methods rm,
3644: ar_receipt_classes rc,
3645: hz_cust_accounts hca,
3646: hz_parties party,
3647: ar_remit_gt g
3648: WHERE cr.selected_remittance_batch_id = p_batch_id