DBA Data[Home] [Help]

APPS.PAY_IN_EOY_REPORTS dependencies on DUAL

Line 305: FROM DUAL;

301: l_location_state || DECODE(l_location_state ,NULL,NULL,',')||
302: l_location_country || DECODE(l_location_country ,NULL,NULL,',')||
303: l_location_zipcode
304: INTO l_details
305: FROM DUAL;
306:
307: ELSIF p_field = 'EMPLOYER_ADDRESS1' THEN
308: l_details := l_location_address1;
309: ELSIF p_field = 'EMPLOYER_ADDRESS2' THEN

Line 417: FROM DUAL;

413: l_location_city || DECODE(l_location_city ,NULL,NULL,',' || fnd_global.local_chr(10)) ||
414: l_location_state || DECODE(l_location_state ,NULL,NULL,',' || fnd_global.local_chr(10)) ||
415: l_location_country
416: INTO l_details
417: FROM DUAL;
418:
419: ELSIF p_field = 'ADDRESS1' THEN
420: l_details := l_location_address1;
421: ELSIF p_field = 'ADDRESS2' THEN

Line 1528: FROM dual

1524:
1525: select lower(fnd_global.local_chr(r+64)) INTO l_seq
1526: FROM
1527: ( SELECT LEVEL r
1528: FROM dual
1529: CONNECT BY LEVEL <= 26 )
1530: WHERE r+64 = 72 + l_count;
1531:
1532: l_open_tag := '';