[Home] [Help]
582: )
583: from ra_customer_trx ctrx,
584: hz_cust_site_uses rsu_st,
585: hz_cust_site_uses rsu_bt,
586: ar_system_parameters sp
587: where ctrx.customer_trx_id = p_customer_trx_id
588: and ctrx.org_id = p_org_id
589: and sp.org_id = p_org_id
590: and ctrx.bill_to_site_use_id = rsu_bt.site_use_id(+)
615: select rt.receivables_trx_id
616: into l_penalty_receivables_trx_id
617: from ar_receivables_trx rt
618: where rt.receivables_trx_id = (select sp.penalty_rec_trx_id
619: from ar_system_parameters sp
620: where sp.org_id = p_org_id)
621: and rt.type = 'FINCHRG'
622: and nvl(rt.status,'A') = 'A'
623: and rt.org_id = p_org_id
1234: hz_parties party,
1235: hz_customer_profiles profiles,
1236: hz_cust_profile_amts prof_amts,
1237: hz_cust_site_uses site_use,
1238: ar_system_parameters sysparam
1239: WHERE cust_acct.party_id = party.party_id
1240: '|| l_customer_name_where ||'
1241: '|| l_customer_number_where || '
1242: AND cust_acct.status = ''A''
3736: | receipt grace days is subtracted from this. If this balance is atleast the min |
3737: | customer balance threshold, charge will be calculated. |
3738: | b) Charge computation |
3739: | Based on the set up in post_billing_debit_items and late_charge_billing_calc_mode,|
3740: | (in ar_system_parameters), different items and date range will be used to |
3741: | calculate the average daily balance |
3742: | c) Generation of the document in AR. |
3743: | 2. The following fields are not used for Average Daily Balance |
3744: | a) credit_items_flag |
3942: cust_sites.min_fc_balance_amount,
3943: cust_sites.min_fc_balance_percent
3944: from ar_cons_inv cons_inv,
3945: ar_lc_cust_sites_t cust_sites,
3946: ar_system_parameters sysparam
3947: where cons_inv.customer_id = cust_sites.customer_id
3948: and cons_inv.site_use_id = cust_sites.customer_site_use_id
3949: and cons_inv.currency_code = cust_sites.currency_code
3950: and mod(nvl(cust_sites.customer_site_use_id,0),l_total_workers) =
4022: cust_site.min_fc_balance_overdue_type,
4023: cust_site.min_fc_balance_amount,
4024: cust_site.min_fc_balance_percent
4025: from ar_lc_cust_sites_t cust_site,
4026: ar_system_parameters sysparam
4027: where sysparam.org_id = cust_site.org_id
4028: and sysparam.late_charge_billing_calc_mode = 'RUN_TO_RUN_DATE'
4029: and cust_site.late_charge_calculation_trx = 'AVG_DAILY_BALANCE'
4030: and mod(nvl(cust_site.customer_site_use_id,0),l_total_workers) =
4074: cust_sites.min_fc_balance_amount,
4075: cust_sites.min_fc_balance_percent
4076: from ar_payment_schedules ps,
4077: ar_lc_cust_sites_t cust_sites,
4078: ar_system_parameters sysparam
4079: where ps.customer_id = cust_sites.customer_id
4080: and decode(ps.class,
4081: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
4082: ps.customer_site_use_id,
4322: cust_sites.min_fc_balance_amount,
4323: cust_sites.min_fc_balance_percent
4324: from ar_cons_inv cons_inv,
4325: ar_lc_cust_sites_t cust_sites,
4326: ar_system_parameters sysparam
4327: where cons_inv.customer_id = cust_sites.customer_id
4328: and cons_inv.site_use_id = cust_sites.customer_site_use_id
4329: and cons_inv.currency_code = cust_sites.currency_code
4330: and mod(nvl(cust_sites.customer_site_use_id,0),l_total_workers) =
4386: cust_sites.min_fc_balance_amount,
4387: cust_sites.min_fc_balance_percent
4388: from ar_payment_schedules ps,
4389: ar_lc_cust_sites_t cust_sites,
4390: ar_system_parameters sysparam
4391: where ps.customer_id = cust_sites.customer_id
4392: and decode(ps.class,
4393: 'BR',ar_calc_late_charge.get_bill_to_site_use_id(ps.customer_id,
4394: ps.customer_site_use_id,
5166: 'N',
5167: l_srs_request_id,
5168: sysparam.org_id,
5169: 1
5170: from ar_system_parameters sysparam
5171: where nvl(l_operating_unit_id,sysparam.org_id) = sysparam.org_id);
5172:
5173: IF l_debug_flag = 'Y' THEN
5174: debug( 'ar_calc_late_charge.insert_int_batches()-' );
5339: trx.org_id,
5340: trx.display_flag) hdr,
5341: ar_lc_cust_sites_t cust_site,
5342: ar_interest_batches bat,
5343: ar_system_parameters sysparam
5344: where hdr.customer_id = cust_site.customer_id
5345: and hdr.customer_site_use_id = cust_site.customer_site_use_id
5346: and hdr.currency_code = cust_site.currency_code
5347: and mod(nvl(cust_site.customer_site_use_id,0),p_total_workers) =
6656: /* Check if late_charge calculation is enabled in system options */
6657: IF l_org_id IS NOT NULL THEN
6658: select allow_late_charges, set_of_books_id
6659: into l_compute_late_charge, l_set_of_books_id
6660: from ar_system_parameters
6661: where org_id = l_org_id ;
6662: IF l_debug_flag = 'Y' THEN
6663: debug('Running the Program for a single Operating Unit');
6664: debug('Late Charge option in System Options : '||l_compute_late_charge);