APPS.IEX_AGING_BUCKETS_PKG dependencies on RA_CM_REQUESTS

Line 2906: FROM ra_cm_requests

2902: For coll_bkt_cnt IN 1..l_collectible_bkt_id_tbl.COUNT
2903: LOOP
2904: SELECT nvl(SUM(total_amount), 0)
2905: INTO l_collect_dispute_amt
2906: FROM ra_cm_requests
2907: WHERE customer_trx_id IN
2908: (SELECT DISTINCT id.transaction_id
2909: FROM ar_aging_bucket_lines aabl,
2910: ar_payment_schedules aps,

Line 2966: FROM ra_cm_requests

2962: For coll_bkt_cnt IN 1..l_collectible_bkt_id_tbl.COUNT
2963: LOOP
2964: SELECT nvl(SUM(total_amount), 0)
2965: INTO l_collect_dispute_amt
2966: FROM ra_cm_requests
2967: WHERE customer_trx_id IN
2968: (SELECT DISTINCT id.transaction_id
2969: FROM ar_aging_bucket_lines aabl,
2970: ar_payment_schedules aps,

Line 3027: FROM ra_cm_requests

3023: For coll_bkt_cnt IN 1..l_collectible_bkt_id_tbl.COUNT
3024: LOOP
3025: SELECT nvl(SUM(total_amount), 0)
3026: INTO l_collect_dispute_amt
3027: FROM ra_cm_requests
3028: WHERE customer_trx_id IN
3029: (SELECT DISTINCT id.transaction_id
3030: FROM ar_aging_bucket_lines aabl,
3031: ar_payment_schedules aps,

Line 3079: FROM ra_cm_requests

3075: For coll_bkt_cnt IN 1..l_collectible_bkt_id_tbl.COUNT
3076: LOOP
3077: SELECT nvl(SUM(total_amount), 0)
3078: INTO l_collect_dispute_amt
3079: FROM ra_cm_requests
3080: WHERE customer_trx_id IN
3081: (SELECT DISTINCT id.transaction_id
3082: FROM ar_aging_bucket_lines aabl,
3083: ar_payment_schedules aps,