eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_ALIAS_UTILITY dependencies on DUAL

Line 3000: from dual;

2996: l_x_select:=x_select;
2997:
2998: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_1'')', ':'||p_block_name||'ATTR_ID_1')
2999: into l_x_select
3000: from dual;
3001:
3002: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_2'')', ':'||p_block_name||'ATTR_ID_2')
3003: into l_x_select
3004: from dual;

Line 3004: from dual;

3000: from dual;
3001:
3002: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_2'')', ':'||p_block_name||'ATTR_ID_2')
3003: into l_x_select
3004: from dual;
3005:
3006: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_3'')', ':'||p_block_name||'ATTR_ID_3')
3007: into l_x_select
3008: from dual;

Line 3008: from dual;

3004: from dual;
3005:
3006: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_3'')', ':'||p_block_name||'ATTR_ID_3')
3007: into l_x_select
3008: from dual;
3009:
3010: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_4'')', ':'||p_block_name||'ATTR_ID_4')
3011: into l_x_select
3012: from dual;

Line 3012: from dual;

3008: from dual;
3009:
3010: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_4'')', ':'||p_block_name||'ATTR_ID_4')
3011: into l_x_select
3012: from dual;
3013:
3014: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_5'')', ':'||p_block_name||'ATTR_ID_5')
3015: into l_x_select
3016: from dual;

Line 3016: from dual;

3012: from dual;
3013:
3014: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_5'')', ':'||p_block_name||'ATTR_ID_5')
3015: into l_x_select
3016: from dual;
3017:
3018: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_6'')', ':'||p_block_name||'ATTR_ID_6')
3019: into l_x_select
3020: from dual;

Line 3020: from dual;

3016: from dual;
3017:
3018: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_6'')', ':'||p_block_name||'ATTR_ID_6')
3019: into l_x_select
3020: from dual;
3021:
3022: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_7'')', ':'||p_block_name||'ATTR_ID_7')
3023: into l_x_select
3024: from dual;

Line 3024: from dual;

3020: from dual;
3021:
3022: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_7'')', ':'||p_block_name||'ATTR_ID_7')
3023: into l_x_select
3024: from dual;
3025:
3026: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_8'')', ':'||p_block_name||'ATTR_ID_8')
3027: into l_x_select
3028: from dual;

Line 3028: from dual;

3024: from dual;
3025:
3026: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_8'')', ':'||p_block_name||'ATTR_ID_8')
3027: into l_x_select
3028: from dual;
3029:
3030: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_9'')', ':'||p_block_name||'ATTR_ID_9')
3031: into l_x_select
3032: from dual;

Line 3032: from dual;

3028: from dual;
3029:
3030: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_9'')', ':'||p_block_name||'ATTR_ID_9')
3031: into l_x_select
3032: from dual;
3033:
3034: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_10'')', ':'||p_block_name||'ATTR_ID_10')
3035: into l_x_select
3036: from dual;

Line 3036: from dual;

3032: from dual;
3033:
3034: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_10'')', ':'||p_block_name||'ATTR_ID_10')
3035: into l_x_select
3036: from dual;
3037:
3038: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_11'')', ':'||p_block_name||'ATTR_ID_11')
3039: into l_x_select
3040: from dual;

Line 3040: from dual;

3036: from dual;
3037:
3038: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_11'')', ':'||p_block_name||'ATTR_ID_11')
3039: into l_x_select
3040: from dual;
3041:
3042: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_12'')', ':'||p_block_name||'ATTR_ID_12')
3043: into l_x_select
3044: from dual;

Line 3044: from dual;

3040: from dual;
3041:
3042: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_12'')', ':'||p_block_name||'ATTR_ID_12')
3043: into l_x_select
3044: from dual;
3045:
3046: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_13'')', ':'||p_block_name||'ATTR_ID_13')
3047: into l_x_select
3048: from dual;

Line 3048: from dual;

3044: from dual;
3045:
3046: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_13'')', ':'||p_block_name||'ATTR_ID_13')
3047: into l_x_select
3048: from dual;
3049:
3050: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_14'')', ':'||p_block_name||'ATTR_ID_14')
3051: into l_x_select
3052: from dual;

Line 3052: from dual;

3048: from dual;
3049:
3050: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_14'')', ':'||p_block_name||'ATTR_ID_14')
3051: into l_x_select
3052: from dual;
3053:
3054: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_15'')', ':'||p_block_name||'ATTR_ID_15')
3055: into l_x_select
3056: from dual;

Line 3056: from dual;

3052: from dual;
3053:
3054: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_15'')', ':'||p_block_name||'ATTR_ID_15')
3055: into l_x_select
3056: from dual;
3057:
3058: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_16'')', ':'||p_block_name||'ATTR_ID_16')
3059: into l_x_select
3060: from dual;

Line 3060: from dual;

3056: from dual;
3057:
3058: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_16'')', ':'||p_block_name||'ATTR_ID_16')
3059: into l_x_select
3060: from dual;
3061:
3062: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_17'')', ':'||p_block_name||'ATTR_ID_17')
3063: into l_x_select
3064: from dual;

Line 3064: from dual;

3060: from dual;
3061:
3062: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_17'')', ':'||p_block_name||'ATTR_ID_17')
3063: into l_x_select
3064: from dual;
3065:
3066: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_18'')', ':'||p_block_name||'ATTR_ID_18')
3067: into l_x_select
3068: from dual;

Line 3068: from dual;

3064: from dual;
3065:
3066: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_18'')', ':'||p_block_name||'ATTR_ID_18')
3067: into l_x_select
3068: from dual;
3069:
3070: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_19'')', ':'||p_block_name||'ATTR_ID_19')
3071: into l_x_select
3072: from dual;

Line 3072: from dual;

3068: from dual;
3069:
3070: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_19'')', ':'||p_block_name||'ATTR_ID_19')
3071: into l_x_select
3072: from dual;
3073:
3074: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_20'')', ':'||p_block_name||'ATTR_ID_20')
3075: into l_x_select
3076: from dual;

Line 3076: from dual;

3072: from dual;
3073:
3074: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_20'')', ':'||p_block_name||'ATTR_ID_20')
3075: into l_x_select
3076: from dual;
3077:
3078: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_RESOURCE_ID'')', ':'||'TIMECARD_INFO.'||'RESOURCE_ID')
3079: into l_x_select
3080: from dual;

Line 3080: from dual;

3076: from dual;
3077:
3078: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_RESOURCE_ID'')', ':'||'TIMECARD_INFO.'||'RESOURCE_ID')
3079: into l_x_select
3080: from dual;
3081:
3082: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_TIMEKEEPER_ID'')', ':'||'HXCTKSTA.TIMEKEEPER_ID')
3083: into l_x_select
3084: from dual;

Line 3084: from dual;

3080: from dual;
3081:
3082: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_TIMEKEEPER_ID'')', ':'||'HXCTKSTA.TIMEKEEPER_ID')
3083: into l_x_select
3084: from dual;
3085:
3086: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_START_DATE'')', ':'||'HXCTKSTA.'||'FRDT')
3087: into l_x_select
3088: from dual;

Line 3088: from dual;

3084: from dual;
3085:
3086: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_START_DATE'')', ':'||'HXCTKSTA.'||'FRDT')
3087: into l_x_select
3088: from dual;
3089:
3090: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_END_DATE'')', ':'||'HXCTKSTA.'||'TODT')
3091: into l_x_select
3092: from dual;

Line 3092: from dual;

3088: from dual;
3089:
3090: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_END_DATE'')', ':'||'HXCTKSTA.'||'TODT')
3091: into l_x_select
3092: from dual;
3093:
3094:
3095: return l_x_select;
3096: