APPS.IEX_AGING_BUCKETS_PKG dependencies on FND_PROFILE

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

2916: --- End - Andre Araujo - 11/09/2004 - Performance fix
2917: group by aabl.aging_bucket_line_id ;
2918:
2919: --Start bug 6701396 gnramasa 4th Mar 08
2920: if (NVL(FND_PROFILE.VALUE('IEX_EXCLUDE_DISPUTE_AMT_FROM_REMAINING_AMT'), 'N') = 'Y') then
2921: if l_collectible_bkt_id_tbl.COUNT > 0 then
2922: For coll_bkt_cnt IN 1..l_collectible_bkt_id_tbl.COUNT
2923: LOOP
2924: SELECT nvl(SUM(total_amount), 0)

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

2976: AND aps.status = 'OP'
2977: --- End - Andre Araujo - 11/09/2004 - Performance fix
2978: group by aabl.aging_bucket_line_id ;
2979:
2980: if (NVL(FND_PROFILE.VALUE('IEX_EXCLUDE_DISPUTE_AMT_FROM_REMAINING_AMT'), 'N') = 'Y') then
2981: if l_collectible_bkt_id_tbl.COUNT > 0 then
2982: For coll_bkt_cnt IN 1..l_collectible_bkt_id_tbl.COUNT
2983: LOOP
2984: SELECT nvl(SUM(total_amount), 0)

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

3037: AND aps.status = 'OP'
3038: --- End - Andre Araujo - 11/09/2004 - Performance fix
3039: group by aabl.aging_bucket_line_id ;
3040:
3041: if (NVL(FND_PROFILE.VALUE('IEX_EXCLUDE_DISPUTE_AMT_FROM_REMAINING_AMT'), 'N') = 'Y') then
3042: if l_collectible_bkt_id_tbl.COUNT > 0 then
3043: For coll_bkt_cnt IN 1..l_collectible_bkt_id_tbl.COUNT
3044: LOOP
3045: SELECT nvl(SUM(total_amount), 0)

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

3089: AND aps.status = 'OP'
3090: --- End - Andre Araujo - 11/09/2004 - Performance fix
3091: group by aabl.aging_bucket_line_id ; -- added by ehuh for bill-to
3092:
3093: if (NVL(FND_PROFILE.VALUE('IEX_EXCLUDE_DISPUTE_AMT_FROM_REMAINING_AMT'), 'N') = 'Y') then
3094: if l_collectible_bkt_id_tbl.COUNT > 0 then
3095: For coll_bkt_cnt IN 1..l_collectible_bkt_id_tbl.COUNT
3096: LOOP
3097: SELECT nvl(SUM(total_amount), 0)