APPS.AR_CALC_LATE_CHARGE dependencies on AR_AGING_BUCKET_LINES

Line 519: ar_aging_bucket_lines bucket_lines

515: 'MONTHLY',first_day(int_lines.due_date))
516: ) b,
517: ar_charge_schedule_hdrs sched_hdrs,
518: ar_charge_schedule_lines sched_lines,
519: ar_aging_bucket_lines bucket_lines
520: where b.interest_schedule_id = sched_hdrs.schedule_id(+)
521: and sched_hdrs.schedule_header_id = sched_lines.schedule_header_id(+)
522: and sched_hdrs.schedule_id = sched_lines.schedule_id(+)
523: and nvl(sched_hdrs.status,'A') = 'A'

Line 2708: ar_aging_bucket_lines bucket_lines

2704: and b.org_id = credits.org_id (+)
2705: and b.legal_entity_id = credits.legal_entity_id(+))c,
2706: ar_charge_schedule_hdrs sched_hdrs,
2707: ar_charge_schedule_lines sched_lines,
2708: ar_aging_bucket_lines bucket_lines
2709: where c.interest_schedule_id = sched_hdrs.schedule_id(+)
2710: and sched_hdrs.schedule_header_id = sched_lines.schedule_header_id(+)
2711: and sched_hdrs.schedule_id = sched_lines.schedule_id(+)
2712: and nvl(sched_hdrs.status,'A') = 'A'

Line 3580: ar_aging_bucket_lines bucket_lines

3576: 'DAILY',a.due_date,
3577: 'MONTHLY',first_day(a.due_date)))b,
3578: ar_charge_schedule_hdrs sched_hdrs,
3579: ar_charge_schedule_lines sched_lines,
3580: ar_aging_bucket_lines bucket_lines
3581: where b.interest_schedule_id = sched_hdrs.schedule_id(+)
3582: and sched_hdrs.schedule_header_id = sched_lines.schedule_header_id(+)
3583: and sched_hdrs.schedule_id = sched_lines.schedule_id(+)
3584: and nvl(sched_hdrs.status,'A') = 'A'

Line 4068: ar_aging_bucket_lines bucket_lines

4064: cust_site.late_charge_calculation_trx,
4065: cr.cash_receipt_id) a,
4066: ar_charge_schedule_hdrs sched_hdrs,
4067: ar_charge_schedule_lines sched_lines,
4068: ar_aging_bucket_lines bucket_lines
4069: where a.interest_schedule_id = sched_hdrs.schedule_id(+)
4070: and sched_hdrs.schedule_header_id = sched_lines.schedule_header_id(+)
4071: and sched_hdrs.schedule_id = sched_lines.schedule_id(+)
4072: and nvl(sched_hdrs.status,'A') = 'A'

Line 5416: ar_aging_bucket_lines bucket_lines

5412: from ar_lc_cust_sites_t cust_site,
5413: ar_late_charge_trx_t trx,
5414: ar_charge_schedule_hdrs sched_hdrs,
5415: ar_charge_schedule_lines sched_lines,
5416: ar_aging_bucket_lines bucket_lines
5417: where cust_site.customer_id = trx.customer_id
5418: and cust_site.customer_site_use_id = trx.customer_site_use_id
5419: and cust_site.currency_code = trx.currency_code
5420: and mod(nvl(cust_site.customer_site_use_id,0),p_total_workers) =