APPS.ASL_EXCEL_UTIL_PVT dependencies on DUAL

Line 196: FROM DUAL

192: FROM MTL_ITEM_CATEGORIES
193: WHERE ORGANIZATION_ID = p_org_id
194: AND CATEGORY_ID in
195: (SELECT FND_PROFILE.VALUE_SPECIFIC('ASL_EXCEL_INV_CATEGORY',p_user_id,p_resp_id,p_app_id)
196: FROM DUAL
197: );
198:
199: */
200: l_inv_categories varchar(2000) := '';

Line 212: FROM DUAL;

208: l_old_inv_catgry_rec ASL_OLD_INV_CATEGORY_REC_TYPE;
209: BEGIN
210: SELECT FND_PROFILE.VALUE_SPECIFIC('ASL_EXCEL_INV_CATEGORY',p_user_id, p_resp_id, p_app_id)
211: INTO l_inv_categories
212: FROM DUAL;
213:
214: FOR r_old_inv_catgry_rec IN C_DOWNLOADED_INV_CATEGORY (p_org_id,p_user_id,p_app_id,p_resp_id) LOOP
215: IF (r_old_inv_catgry_rec.category_id < M_SERVER_PK_ID_MAX) THEN
216: l_old_inv_catgry_rec.category_id := r_old_inv_catgry_rec.category_id;

Line 251: SELECT FND_PROFILE.VALUE_SPECIFIC('ASL_EXCEL_PRICE_LIST',p_user_id,p_resp_id,p_app_id) into l_prof_price_list_headers FROM DUAL;

247: FROM QP_LIST_HEADERS_B
248: WHERE LIST_HEADER_ID = p_header_id;
249: BEGIN
250:
251: SELECT FND_PROFILE.VALUE_SPECIFIC('ASL_EXCEL_PRICE_LIST',p_user_id,p_resp_id,p_app_id) into l_prof_price_list_headers FROM DUAL;
252: l_prof_price_list_headers := replace( l_prof_price_list_headers ,'(','');
253: l_prof_price_list_headers := replace( l_prof_price_list_headers ,')','');
254: l_prof_price_list_headers := replace( l_prof_price_list_headers ,fnd_global.local_chr(39),'');
255:

Line 416: SELECT SYSDATE INTO t_current_sync_time FROM DUAL;

412: */
413: /*
414: ** Get the current sysdate for SYNC_TIME of this sync transaction
415: */
416: SELECT SYSDATE INTO t_current_sync_time FROM DUAL;
417:
418: x_curr_sync_time_str := TO_CHAR(t_current_sync_time, M_CONVERSION_DATE_FORMAT);
419:
420: IF (M_FULL_SYNC) THEN