DBA Data[Home] [Help]

APPS.HXC_ALIAS_UTILITY dependencies on DUAL

Line 2684: from dual;

2680: l_x_select:=x_select;
2681:
2682: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_1'')', ':'||p_block_name||'ATTR_ID_1')
2683: into l_x_select
2684: from dual;
2685:
2686: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_2'')', ':'||p_block_name||'ATTR_ID_2')
2687: into l_x_select
2688: from dual;

Line 2688: from dual;

2684: from dual;
2685:
2686: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_2'')', ':'||p_block_name||'ATTR_ID_2')
2687: into l_x_select
2688: from dual;
2689:
2690: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_3'')', ':'||p_block_name||'ATTR_ID_3')
2691: into l_x_select
2692: from dual;

Line 2692: from dual;

2688: from dual;
2689:
2690: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_3'')', ':'||p_block_name||'ATTR_ID_3')
2691: into l_x_select
2692: from dual;
2693:
2694: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_4'')', ':'||p_block_name||'ATTR_ID_4')
2695: into l_x_select
2696: from dual;

Line 2696: from dual;

2692: from dual;
2693:
2694: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_4'')', ':'||p_block_name||'ATTR_ID_4')
2695: into l_x_select
2696: from dual;
2697:
2698: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_5'')', ':'||p_block_name||'ATTR_ID_5')
2699: into l_x_select
2700: from dual;

Line 2700: from dual;

2696: from dual;
2697:
2698: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_5'')', ':'||p_block_name||'ATTR_ID_5')
2699: into l_x_select
2700: from dual;
2701:
2702: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_6'')', ':'||p_block_name||'ATTR_ID_6')
2703: into l_x_select
2704: from dual;

Line 2704: from dual;

2700: from dual;
2701:
2702: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_6'')', ':'||p_block_name||'ATTR_ID_6')
2703: into l_x_select
2704: from dual;
2705:
2706: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_7'')', ':'||p_block_name||'ATTR_ID_7')
2707: into l_x_select
2708: from dual;

Line 2708: from dual;

2704: from dual;
2705:
2706: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_7'')', ':'||p_block_name||'ATTR_ID_7')
2707: into l_x_select
2708: from dual;
2709:
2710: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_8'')', ':'||p_block_name||'ATTR_ID_8')
2711: into l_x_select
2712: from dual;

Line 2712: from dual;

2708: from dual;
2709:
2710: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_8'')', ':'||p_block_name||'ATTR_ID_8')
2711: into l_x_select
2712: from dual;
2713:
2714: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_9'')', ':'||p_block_name||'ATTR_ID_9')
2715: into l_x_select
2716: from dual;

Line 2716: from dual;

2712: from dual;
2713:
2714: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_9'')', ':'||p_block_name||'ATTR_ID_9')
2715: into l_x_select
2716: from dual;
2717:
2718: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_10'')', ':'||p_block_name||'ATTR_ID_10')
2719: into l_x_select
2720: from dual;

Line 2720: from dual;

2716: from dual;
2717:
2718: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_10'')', ':'||p_block_name||'ATTR_ID_10')
2719: into l_x_select
2720: from dual;
2721:
2722: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_11'')', ':'||p_block_name||'ATTR_ID_11')
2723: into l_x_select
2724: from dual;

Line 2724: from dual;

2720: from dual;
2721:
2722: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_11'')', ':'||p_block_name||'ATTR_ID_11')
2723: into l_x_select
2724: from dual;
2725:
2726: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_12'')', ':'||p_block_name||'ATTR_ID_12')
2727: into l_x_select
2728: from dual;

Line 2728: from dual;

2724: from dual;
2725:
2726: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_12'')', ':'||p_block_name||'ATTR_ID_12')
2727: into l_x_select
2728: from dual;
2729:
2730: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_13'')', ':'||p_block_name||'ATTR_ID_13')
2731: into l_x_select
2732: from dual;

Line 2732: from dual;

2728: from dual;
2729:
2730: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_13'')', ':'||p_block_name||'ATTR_ID_13')
2731: into l_x_select
2732: from dual;
2733:
2734: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_14'')', ':'||p_block_name||'ATTR_ID_14')
2735: into l_x_select
2736: from dual;

Line 2736: from dual;

2732: from dual;
2733:
2734: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_14'')', ':'||p_block_name||'ATTR_ID_14')
2735: into l_x_select
2736: from dual;
2737:
2738: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_15'')', ':'||p_block_name||'ATTR_ID_15')
2739: into l_x_select
2740: from dual;

Line 2740: from dual;

2736: from dual;
2737:
2738: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_15'')', ':'||p_block_name||'ATTR_ID_15')
2739: into l_x_select
2740: from dual;
2741:
2742: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_16'')', ':'||p_block_name||'ATTR_ID_16')
2743: into l_x_select
2744: from dual;

Line 2744: from dual;

2740: from dual;
2741:
2742: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_16'')', ':'||p_block_name||'ATTR_ID_16')
2743: into l_x_select
2744: from dual;
2745:
2746: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_17'')', ':'||p_block_name||'ATTR_ID_17')
2747: into l_x_select
2748: from dual;

Line 2748: from dual;

2744: from dual;
2745:
2746: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_17'')', ':'||p_block_name||'ATTR_ID_17')
2747: into l_x_select
2748: from dual;
2749:
2750: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_18'')', ':'||p_block_name||'ATTR_ID_18')
2751: into l_x_select
2752: from dual;

Line 2752: from dual;

2748: from dual;
2749:
2750: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_18'')', ':'||p_block_name||'ATTR_ID_18')
2751: into l_x_select
2752: from dual;
2753:
2754: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_19'')', ':'||p_block_name||'ATTR_ID_19')
2755: into l_x_select
2756: from dual;

Line 2756: from dual;

2752: from dual;
2753:
2754: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_19'')', ':'||p_block_name||'ATTR_ID_19')
2755: into l_x_select
2756: from dual;
2757:
2758: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_20'')', ':'||p_block_name||'ATTR_ID_20')
2759: into l_x_select
2760: from dual;

Line 2760: from dual;

2756: from dual;
2757:
2758: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_ATTR_20'')', ':'||p_block_name||'ATTR_ID_20')
2759: into l_x_select
2760: from dual;
2761:
2762: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_RESOURCE_ID'')', ':'||'TIMECARD_INFO.'||'RESOURCE_ID')
2763: into l_x_select
2764: from dual;

Line 2764: from dual;

2760: from dual;
2761:
2762: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_RESOURCE_ID'')', ':'||'TIMECARD_INFO.'||'RESOURCE_ID')
2763: into l_x_select
2764: from dual;
2765:
2766: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_TIMEKEEPER_ID'')', ':'||'HXCTKSTA.TIMEKEEPER_ID')
2767: into l_x_select
2768: from dual;

Line 2768: from dual;

2764: from dual;
2765:
2766: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_TIMEKEEPER_ID'')', ':'||'HXCTKSTA.TIMEKEEPER_ID')
2767: into l_x_select
2768: from dual;
2769:
2770: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_START_DATE'')', ':'||'HXCTKSTA.'||'FRDT')
2771: into l_x_select
2772: from dual;

Line 2772: from dual;

2768: from dual;
2769:
2770: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_START_DATE'')', ':'||'HXCTKSTA.'||'FRDT')
2771: into l_x_select
2772: from dual;
2773:
2774: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_END_DATE'')', ':'||'HXCTKSTA.'||'TODT')
2775: into l_x_select
2776: from dual;

Line 2776: from dual;

2772: from dual;
2773:
2774: select replace (upper(l_x_select),'FND_PROFILE.VALUE(''OTL_TK_END_DATE'')', ':'||'HXCTKSTA.'||'TODT')
2775: into l_x_select
2776: from dual;
2777:
2778:
2779: return l_x_select;
2780: