APPS.IEX_AGING_BUCKETS_PKG dependencies on RA_CM_REQUESTS

Line 2926: FROM ra_cm_requests

2922: For coll_bkt_cnt IN 1..l_collectible_bkt_id_tbl.COUNT
2923: LOOP
2924: SELECT nvl(SUM(total_amount), 0)
2925: INTO l_collect_dispute_amt
2926: FROM ra_cm_requests
2927: WHERE customer_trx_id IN
2928: (SELECT DISTINCT id.transaction_id
2929: FROM ar_aging_bucket_lines aabl,
2930: ar_payment_schedules aps,

Line 2986: FROM ra_cm_requests

2982: For coll_bkt_cnt IN 1..l_collectible_bkt_id_tbl.COUNT
2983: LOOP
2984: SELECT nvl(SUM(total_amount), 0)
2985: INTO l_collect_dispute_amt
2986: FROM ra_cm_requests
2987: WHERE customer_trx_id IN
2988: (SELECT DISTINCT id.transaction_id
2989: FROM ar_aging_bucket_lines aabl,
2990: ar_payment_schedules aps,

Line 3047: FROM ra_cm_requests

3043: For coll_bkt_cnt IN 1..l_collectible_bkt_id_tbl.COUNT
3044: LOOP
3045: SELECT nvl(SUM(total_amount), 0)
3046: INTO l_collect_dispute_amt
3047: FROM ra_cm_requests
3048: WHERE customer_trx_id IN
3049: (SELECT DISTINCT id.transaction_id
3050: FROM ar_aging_bucket_lines aabl,
3051: ar_payment_schedules aps,

Line 3099: FROM ra_cm_requests

3095: For coll_bkt_cnt IN 1..l_collectible_bkt_id_tbl.COUNT
3096: LOOP
3097: SELECT nvl(SUM(total_amount), 0)
3098: INTO l_collect_dispute_amt
3099: FROM ra_cm_requests
3100: WHERE customer_trx_id IN
3101: (SELECT DISTINCT id.transaction_id
3102: FROM ar_aging_bucket_lines aabl,
3103: ar_payment_schedules aps,