APPS.AR_CALC_LATE_CHARGE dependencies on AR_LATE_CHARGE_CUST_BALANCE_GT

Line 412: ar_late_charge_cust_balance_gt bal

408: ar_interest_headers int_headers,
409: ar_cash_receipts cr,
410: ar_payment_schedules ps,
411: ar_lc_cust_sites_t cust_site,
412: ar_late_charge_cust_balance_gt bal
413: where ps.customer_id = cust_site.customer_id
414: and cust_site.customer_site_use_id = decode(ps.class,
415: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
416: ps.customer_site_use_id,

Line 1838: ar_late_charge_cust_balance_gt bal

1834: -1* ps.amount_due_remaining balance_due
1835: from ar_cash_receipts cr,
1836: ar_payment_schedules ps,
1837: ar_lc_cust_sites_t cust_site,
1838: ar_late_charge_cust_balance_gt bal
1839: where ps.actual_date_closed > l_fin_charge_date
1840: and ps.class ='PMT'
1841: and ps.trx_date <= l_fin_charge_date
1842: and nvl(ps.last_charge_date,l_fin_charge_date-1) < l_fin_charge_date

Line 1887: ar_late_charge_cust_balance_gt bal

1883: from ar_payment_schedules ps,
1884: ra_customer_trx trx,
1885: ra_cust_trx_types types,
1886: ar_lc_cust_sites_t cust_site,
1887: ar_late_charge_cust_balance_gt bal
1888: where ps.customer_id = cust_site.customer_id
1889: and ps.customer_site_use_id = cust_site.customer_site_use_id
1890: and ps.invoice_currency_code = cust_site.currency_code
1891: and mod(nvl(cust_site.customer_site_use_id,0),l_total_workers) =

Line 2359: ar_late_charge_cust_balance_gt bal

2355: 'OVERDUE' charge_type
2356: from ar_payment_schedules ps,
2357: ar_adjustments adj,
2358: ar_lc_cust_sites_t cust_site,
2359: ar_late_charge_cust_balance_gt bal
2360: where ps.customer_id = cust_site.customer_id
2361: and cust_site.customer_site_use_id = decode(ps.class,
2362: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
2363: ps.customer_site_use_id,

Line 2485: ar_late_charge_cust_balance_gt bal

2481: from ar_payment_schedules ps,
2482: ar_receivable_applications app,
2483: ar_payment_schedules ps_cm_cr,
2484: ar_lc_cust_sites_t cust_site,
2485: ar_late_charge_cust_balance_gt bal
2486: where ps.customer_id = cust_site.customer_id
2487: and cust_site.customer_site_use_id = decode(ps.class,
2488: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
2489: ps.customer_site_use_id,

Line 2611: ar_late_charge_cust_balance_gt bal

2607: ps.cash_receipt_id,
2608: 'OVERDUE' charge_type
2609: from ar_payment_schedules ps,
2610: ar_lc_cust_sites_t cust_site,
2611: ar_late_charge_cust_balance_gt bal
2612: where ps.customer_id = cust_site.customer_id
2613: and cust_site.customer_site_use_id = decode(ps.class,
2614: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
2615: ps.customer_site_use_id,

Line 3066: ar_late_charge_cust_balance_gt bal

3062: 'OVERDUE' charge_type
3063: from ar_payment_schedules ps,
3064: ar_adjustments adj,
3065: ar_lc_cust_sites_t cust_site,
3066: ar_late_charge_cust_balance_gt bal
3067: where ps.customer_id = cust_site.customer_id
3068: and cust_site.customer_site_use_id = decode(ps.class,
3069: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
3070: ps.customer_site_use_id,

Line 3207: ar_late_charge_cust_balance_gt bal

3203: from ar_payment_schedules ps,
3204: ar_receivable_applications app,
3205: ar_payment_schedules ps_cm_cr,
3206: ar_lc_cust_sites_t cust_site,
3207: ar_late_charge_cust_balance_gt bal
3208: where ps.customer_id = cust_site.customer_id
3209: and cust_site.customer_site_use_id = decode(ps.class,
3210: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
3211: ps.customer_site_use_id,

Line 3341: ar_late_charge_cust_balance_gt bal

3337: 'OVERDUE' charge_type
3338: from ar_payment_schedules ps,
3339: ar_receivable_applications app,
3340: ar_lc_cust_sites_t cust_site,
3341: ar_late_charge_cust_balance_gt bal
3342: where ps.customer_id = cust_site.customer_id
3343: and cust_site.customer_site_use_id = ps.customer_site_use_id
3344: and ps.invoice_currency_code = cust_site.currency_code
3345: and mod(nvl(cust_site.customer_site_use_id,0),l_total_workers) =

Line 3465: ar_late_charge_cust_balance_gt bal

3461: ps.cash_receipt_id,
3462: 'OVERDUE' charge_type
3463: from ar_payment_schedules ps,
3464: ar_lc_cust_sites_t cust_site,
3465: ar_late_charge_cust_balance_gt bal
3466: where ps.customer_id = cust_site.customer_id
3467: and cust_site.customer_site_use_id = decode(ps.class,
3468: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
3469: ps.customer_site_use_id,

Line 3928: ar_late_charge_cust_balance_gt bal,

3924: cust_site.late_charge_calculation_trx eff_charge_type,
3925: cr.cash_receipt_id
3926: from ar_payment_schedules ps,
3927: ar_lc_cust_sites_t cust_site,
3928: ar_late_charge_cust_balance_gt bal,
3929: ar_receivable_applications app,
3930: ar_cash_receipts cr,
3931: ra_cust_trx_types types,
3932: ra_customer_trx trx,

Line 4900: INSERT INTO ar_late_charge_cust_balance_gt

4896: BEGIN
4897: IF l_debug_flag = 'Y' THEN
4898: debug( 'ar_calc_late_charge.insert_cust_balances()+');
4899: END IF;
4900: INSERT INTO ar_late_charge_cust_balance_gt
4901: (late_charge_cust_sites_id,
4902: customer_id,
4903: customer_site_use_id,
4904: currency_code,

Line 6616: from ar_late_charge_cust_balance_gt

6612: customer_site_use_id,
6613: currency_code,
6614: customer_open_balance,
6615: customer_overdue_balance
6616: from ar_late_charge_cust_balance_gt
6617: order by org_id,
6618: customer_id,
6619: customer_site_use_id,
6620: currency_code;

Line 7199: /* Populate the table ar_late_charge_cust_balance_gt with the customer open balance

7195: p_cust_site_use_id => l_cust_site_use_id,
7196: p_worker_number => l_worker_number,
7197: p_total_workers => l_total_workers);
7198:
7199: /* Populate the table ar_late_charge_cust_balance_gt with the customer open balance
7200: and customer overdue balance for all the selected customer, site ,currency_code
7201: and org combination */
7202:
7203: insert_cust_balances(p_as_of_date => l_fin_charge_date,