DBA Data[Home] [Help]

APPS.PAY_IN_EOY_REPORTS dependencies on DUAL

Line 300: FROM DUAL;

296: l_location_state || DECODE(l_location_state ,NULL,NULL,',')||
297: l_location_country || DECODE(l_location_country ,NULL,NULL,',')||
298: l_location_zipcode
299: INTO l_details
300: FROM DUAL;
301:
302: ELSIF p_field = 'EMPLOYER_ADDRESS1' THEN
303: l_details := l_location_address1;
304: ELSIF p_field = 'EMPLOYER_ADDRESS2' THEN

Line 412: FROM DUAL;

408: l_location_city || DECODE(l_location_city ,NULL,NULL,',' || fnd_global.local_chr(10)) ||
409: l_location_state || DECODE(l_location_state ,NULL,NULL,',' || fnd_global.local_chr(10)) ||
410: l_location_country
411: INTO l_details
412: FROM DUAL;
413:
414: ELSIF p_field = 'ADDRESS1' THEN
415: l_details := l_location_address1;
416: ELSIF p_field = 'ADDRESS2' THEN

Line 1789: FROM dual

1785:
1786: select lower(fnd_global.local_chr(r+64)) INTO l_seq
1787: FROM
1788: ( SELECT LEVEL r
1789: FROM dual
1790: CONNECT BY LEVEL <= 26 )
1791: WHERE r+64 = 72 + l_count;
1792:
1793: l_open_tag := '';