APPS.IEX_COLL_IND dependencies on AR_ADJUSTMENTS

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

897: IF p_party_id IS NOT NULL THEN
898: SELECT
899: sum( nvl(adj.acctd_amount,0))
900: INTO l_adj
901: FROM ar_payment_schedules ps, ar_adjustments adj, hz_cust_accounts ca
902: WHERE ps.class in ('INV', 'DM', 'CB', 'DEP' )
903: AND ps.payment_schedule_id <> -1
904: AND ps.gl_date BETWEEN TRUNC(add_months(sysdate, -12)) AND TRUNC(sysdate)
905: AND ps.customer_id = ca.cust_account_id

Line 914: FROM ar_payment_schedules ps, ar_adjustments adj

910: ELSIF p_cust_account_id IS NOT NULL THEN
911: SELECT
912: sum( nvl(adj.acctd_amount,0))
913: INTO l_adj
914: FROM ar_payment_schedules ps, ar_adjustments adj
915: WHERE ps.class in ('INV', 'DM', 'CB', 'DEP' )
916: AND ps.payment_schedule_id <> -1
917: AND ps.gl_date BETWEEN TRUNC(add_months(sysdate, -12)) AND TRUNC(sysdate)
918: AND ps.customer_id = p_cust_account_id

Line 926: FROM ar_payment_schedules ps, ar_adjustments adj

922: ELSIF p_customer_site_use_id IS NOT NULL THEN
923: SELECT
924: sum( nvl(adj.acctd_amount,0))
925: INTO l_adj
926: FROM ar_payment_schedules ps, ar_adjustments adj
927: WHERE ps.class in ('INV', 'DM', 'CB', 'DEP' )
928: AND ps.payment_schedule_id <> -1
929: AND ps.gl_date BETWEEN TRUNC(add_months(sysdate, -12)) AND TRUNC(sysdate)
930: AND ps.customer_site_use_id = p_customer_site_use_id

Line 1307: FROM ar_adjustments a

1303:
1304: BEGIN
1305: SELECT sum( nvl(a.acctd_amount,0))
1306: INTO l_adj_tot
1307: FROM ar_adjustments a
1308: WHERE a.payment_schedule_id = p_payment_schedule_id
1309: AND a.status = 'A'
1310: AND a.gl_date > p_to_date;
1311:

Line 1335: FROM ar_adjustments a

1331:
1332: BEGIN
1333: SELECT sum( nvl(a.acctd_amount,0))
1334: INTO l_adj_for_tot_rec
1335: FROM ar_adjustments a
1336: WHERE a.payment_schedule_id = p_payment_schedule_id
1337: AND a.status = 'A'
1338: AND a.gl_date <= p_to_date;
1339: