APPS.IEX_COLL_IND dependencies on AR_ADJUSTMENTS

Line 1012: FROM ar_payment_schedules ps, ar_adjustments adj, hz_cust_accounts ca

1008: IF p_party_id IS NOT NULL THEN
1009: SELECT
1010: sum( nvl(adj.acctd_amount,0))
1011: INTO l_adj
1012: FROM ar_payment_schedules ps, ar_adjustments adj, hz_cust_accounts ca
1013: WHERE ps.class in ('INV', 'DM', 'CB', 'DEP' )
1014: AND ps.payment_schedule_id <> -1
1015: AND ps.gl_date BETWEEN TRUNC(add_months(sysdate, -12)) AND TRUNC(sysdate)
1016: AND ps.customer_id = ca.cust_account_id

Line 1025: FROM ar_payment_schedules ps, ar_adjustments adj

1021: ELSIF p_cust_account_id IS NOT NULL THEN
1022: SELECT
1023: sum( nvl(adj.acctd_amount,0))
1024: INTO l_adj
1025: FROM ar_payment_schedules ps, ar_adjustments adj
1026: WHERE ps.class in ('INV', 'DM', 'CB', 'DEP' )
1027: AND ps.payment_schedule_id <> -1
1028: AND ps.gl_date BETWEEN TRUNC(add_months(sysdate, -12)) AND TRUNC(sysdate)
1029: AND ps.customer_id = p_cust_account_id

Line 1037: FROM ar_payment_schedules ps, ar_adjustments adj

1033: ELSIF p_customer_site_use_id IS NOT NULL THEN
1034: SELECT
1035: sum( nvl(adj.acctd_amount,0))
1036: INTO l_adj
1037: FROM ar_payment_schedules ps, ar_adjustments adj
1038: WHERE ps.class in ('INV', 'DM', 'CB', 'DEP' )
1039: AND ps.payment_schedule_id <> -1
1040: AND ps.gl_date BETWEEN TRUNC(add_months(sysdate, -12)) AND TRUNC(sysdate)
1041: AND ps.customer_site_use_id = p_customer_site_use_id

Line 1418: FROM ar_adjustments a

1414:
1415: BEGIN
1416: SELECT sum( nvl(a.acctd_amount,0))
1417: INTO l_adj_tot
1418: FROM ar_adjustments a
1419: WHERE a.payment_schedule_id = p_payment_schedule_id
1420: AND a.status = 'A'
1421: AND a.gl_date <= p_to_date;--Added for Bug 8201317 14-Jun-2010 barathsr
1422:

Line 1446: FROM ar_adjustments a

1442:
1443: BEGIN
1444: SELECT sum( nvl(a.acctd_amount,0))
1445: INTO l_adj_for_tot_rec
1446: FROM ar_adjustments a
1447: WHERE a.payment_schedule_id = p_payment_schedule_id
1448: AND a.status = 'A'
1449: AND a.gl_date <= p_to_date;
1450: