DBA Data[Home] [Help]

APPS.FV_CCR_UTIL_PVT dependencies on FV_CCR_FLAGS

Line 3310: from fv_ccr_flags where duns = p_duns and rownum<=1;

3306: begin
3307: l_module_name := 'fv.plsql.FV_CCR_UTIL_PVT.get_ccr_flag_code';
3308: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,'BEGIN');
3309: select flagtype, flagval into l_flagtype, l_flagval
3310: from fv_ccr_flags where duns = p_duns and rownum<=1;
3311:
3312: if(l_flagtype = 'NPD' AND l_flagval = 'Y') then
3313: begin
3314: select meaning into l_flag_code

Line 3316: where lookup_type like 'FV_CCR_FLAGS'

3312: if(l_flagtype = 'NPD' AND l_flagval = 'Y') then
3313: begin
3314: select meaning into l_flag_code
3315: from fnd_lookup_values
3316: where lookup_type like 'FV_CCR_FLAGS'
3317: and lookup_code = l_flagtype||l_flagval
3318: and language = Userenv('LANG');
3319: exception when no_data_found then
3320: null;

Line 3327: where lookup_type like 'FV_CCR_FLAGS'

3323: ELSIF (l_flagtype = 'NPD') then
3324: begin
3325: select meaning into l_flag_code
3326: from fnd_lookup_values
3327: where lookup_type like 'FV_CCR_FLAGS'
3328: and lookup_code = l_flagtype
3329: and language = Userenv('LANG');
3330: exception when no_data_found then
3331: null;