APPS.AR_IREC_APPLY_CREDITS dependencies on AR_PAYMENT_SCHEDULES

Line 345: | AR_PAYMENT_SCHEDULES to the Apply Credits GT

341: | PUBLIC procedure copy_open_debits
342: |
343: | DESCRIPTION
344: | Copy all open debit transactions for the active customer, site and currency from the
345: | AR_PAYMENT_SCHEDULES to the Apply Credits GT
346: |
347: | PSEUDO CODE/LOGIC
348: |
349: | PARAMETERS

Line 382: | AR_PAYMENT_SCHEDULES to the Apply Credits GT

378: | PUBLIC procedure copy_open_credits
379: |
380: | DESCRIPTION
381: | Copy all open credit transactions for the active customer, site and currency from the
382: | AR_PAYMENT_SCHEDULES to the Apply Credits GT
383: |
384: | PSEUDO CODE/LOGIC
385: |
386: | PARAMETERS

Line 473: from ar_payment_schedules ps, ra_customer_trx ct

469:
470:
471: select class, amount_due_remaining, cash_receipt_id, ct.PAYING_CUSTOMER_ID, ct.PAYING_SITE_USE_ID, ps.CUSTOMER_ID, ps.CUSTOMER_SITE_USE_ID
472: into l_trx_class, l_amount_due_remaining, l_cash_receipt_id, l_pay_for_cust_id, l_pay_for_cust_site_id, l_customer_id, l_customer_site_use_id
473: from ar_payment_schedules ps, ra_customer_trx ct
474: where ps.CUSTOMER_TRX_ID = ct.CUSTOMER_TRX_ID(+)
475: and ps.payment_schedule_id = p_payment_schedule_id;
476:
477: --Bug 4000279 - Modified to check for 'UNAPP' status only

Line 639: FROM ar_payment_schedules ps, hz_cust_accounts hca, ra_terms rt, ra_customer_trx ct

635: l_cash_receipt_id,
636: l_pay_for_cust_id,
637: --Bug 4062938 - Handling of transactions with no site id
638: decode(l_pay_for_cust_site_id, null, -1,l_pay_for_cust_site_id) as customer_site_use_id
639: FROM ar_payment_schedules ps, hz_cust_accounts hca, ra_terms rt, ra_customer_trx ct
640: WHERE ps.payment_schedule_id = p_payment_schedule_id
641: AND ps.customer_id = hca.cust_account_id
642: AND ps.term_id = rt.term_id(+)
643: AND ps.customer_trx_id = ct.customer_trx_id(+);

Line 1166: from ar_payment_schedules

1162: ORDER BY PAYMENT_SCHEDULE_ID;
1163:
1164: CURSOR find_cash_receipt(p_ps_id NUMBER) IS
1165: select cash_receipt_id
1166: from ar_payment_schedules
1167: where payment_schedule_id = p_ps_id;
1168:
1169: debit_trx_record debit_transactions%ROWTYPE;
1170: credit_trx_record credit_transactions%ROWTYPE;

Line 1766: from ar_payment_schedules

1762:
1763: --Bug 4042557: Fetch the GL date for the credit memo
1764: select trunc(gl_date), trunc(trx_date)
1765: into l_gl_date, l_receipt_date
1766: from ar_payment_schedules
1767: where payment_schedule_id = credit_trx_record.payment_schedule_id;
1768:
1769: select trunc(gl_date)
1770: into l_inv_date

Line 1771: from ar_payment_schedules

1767: where payment_schedule_id = credit_trx_record.payment_schedule_id;
1768:
1769: select trunc(gl_date)
1770: into l_inv_date
1771: from ar_payment_schedules
1772: where payment_schedule_id = debit_trx_record.payment_schedule_id;
1773:
1774: --Bug 5911297 - Using apply credit applied GL date profile and pass appropriate gl date
1775: IF(FND_PROFILE.VALUE('AR_APPLICATION_GL_DATE_DEFAULT') = 'INV_REC_SYS_DT') THEN