APPS.IEX_AGING_BUCKETS_PKG dependencies on FND_PROFILE

Line 2900: if (NVL(FND_PROFILE.VALUE('IEX_EXCLUDE_DISPUTE_AMT_FROM_REMAINING_AMT'), 'N') = 'Y') then

2896: --- End - Andre Araujo - 11/09/2004 - Performance fix
2897: group by aabl.aging_bucket_line_id ;
2898:
2899: --Start bug 6701396 gnramasa 4th Mar 08
2900: if (NVL(FND_PROFILE.VALUE('IEX_EXCLUDE_DISPUTE_AMT_FROM_REMAINING_AMT'), 'N') = 'Y') then
2901: if l_collectible_bkt_id_tbl.COUNT > 0 then
2902: For coll_bkt_cnt IN 1..l_collectible_bkt_id_tbl.COUNT
2903: LOOP
2904: SELECT nvl(SUM(total_amount), 0)

Line 2960: if (NVL(FND_PROFILE.VALUE('IEX_EXCLUDE_DISPUTE_AMT_FROM_REMAINING_AMT'), 'N') = 'Y') then

2956: AND aps.status = 'OP'
2957: --- End - Andre Araujo - 11/09/2004 - Performance fix
2958: group by aabl.aging_bucket_line_id ;
2959:
2960: if (NVL(FND_PROFILE.VALUE('IEX_EXCLUDE_DISPUTE_AMT_FROM_REMAINING_AMT'), 'N') = 'Y') then
2961: if l_collectible_bkt_id_tbl.COUNT > 0 then
2962: For coll_bkt_cnt IN 1..l_collectible_bkt_id_tbl.COUNT
2963: LOOP
2964: SELECT nvl(SUM(total_amount), 0)

Line 3021: if (NVL(FND_PROFILE.VALUE('IEX_EXCLUDE_DISPUTE_AMT_FROM_REMAINING_AMT'), 'N') = 'Y') then

3017: AND aps.status = 'OP'
3018: --- End - Andre Araujo - 11/09/2004 - Performance fix
3019: group by aabl.aging_bucket_line_id ;
3020:
3021: if (NVL(FND_PROFILE.VALUE('IEX_EXCLUDE_DISPUTE_AMT_FROM_REMAINING_AMT'), 'N') = 'Y') then
3022: if l_collectible_bkt_id_tbl.COUNT > 0 then
3023: For coll_bkt_cnt IN 1..l_collectible_bkt_id_tbl.COUNT
3024: LOOP
3025: SELECT nvl(SUM(total_amount), 0)

Line 3073: if (NVL(FND_PROFILE.VALUE('IEX_EXCLUDE_DISPUTE_AMT_FROM_REMAINING_AMT'), 'N') = 'Y') then

3069: AND aps.status = 'OP'
3070: --- End - Andre Araujo - 11/09/2004 - Performance fix
3071: group by aabl.aging_bucket_line_id ; -- added by ehuh for bill-to
3072:
3073: if (NVL(FND_PROFILE.VALUE('IEX_EXCLUDE_DISPUTE_AMT_FROM_REMAINING_AMT'), 'N') = 'Y') then
3074: if l_collectible_bkt_id_tbl.COUNT > 0 then
3075: For coll_bkt_cnt IN 1..l_collectible_bkt_id_tbl.COUNT
3076: LOOP
3077: SELECT nvl(SUM(total_amount), 0)