APPS.PER_ZA_WSP_LOOKUP dependencies on DUAL

Line 172: SELECT vsize(P_DESCRIPTION) INTO lenb_desc FROM dual;

168: hr_utility.set_location('fnd_global.lookup_security_group(P_LOOKUP_TYPE,3)'|| fnd_global.lookup_security_group(P_LOOKUP_TYPE,3),1);
169:
170: /*Changes for Bug 6898734 */
171: len_desc:=length(P_DESCRIPTION);
172: SELECT vsize(P_DESCRIPTION) INTO lenb_desc FROM dual;
173:
174: hr_utility.set_location('len_desription:'|| len_desc,1);
175: hr_utility.set_location('len_bytes_desription:'|| lenb_desc,1);
176:

Line 184: SELECT vsize(L_DESCRIPTION) INTO lenb_desc FROM dual;

180: WHILE lenb_desc > 240
181: loop
182: len_desc:=length(L_DESCRIPTION);
183: L_DESCRIPTION:=substr(L_DESCRIPTION,1,len_desc-1);
184: SELECT vsize(L_DESCRIPTION) INTO lenb_desc FROM dual;
185: END loop;
186: hr_utility.set_location('After loop',1);
187:
188: /* End changes for Bug 6898734 */

Line 1960: From Dual;

1956: g_plan_year_start_date
1957: , g_plan_year_end_date
1958: , g_trnd_year_start_date
1959: , g_trnd_year_end_date
1960: From Dual;
1961:
1962: hr_utility.set_location('g_plan_year_start_date :' || g_plan_year_start_date,30);
1963: hr_utility.set_location('g_plan_year_end_date :' || g_plan_year_end_date,30);
1964: hr_utility.set_location('g_trnd_year_start_date :' || g_trnd_year_start_date,30);

Line 2059: from dual;

2055: --
2056: if wsp_lookup_type <> 'NONE' then
2057: select decode(instr(wsp_lookup_type,'ATR'),0,substr(p_lookup_code,1,4),substr(p_lookup_code,1,4)+1)
2058: into wsp_copy_year
2059: from dual;
2060: end if;
2061:
2062:
2063: return wsp_copy_year;