APPS.HR_ADE_ADI_DATA_SETUP dependencies on DUAL

Line 161: FROM dual;

157: --
158: --create object code
159: SELECT hr_adi_object_code_s.NEXTVAL
160: INTO l_object_num
161: FROM dual;
162: -- If Style is "GENERAL", prepend object code with "GENERAL_"
163: IF p_form_name = 'GENERAL' THEN
164: l_object_code := 'GENERAL_'||to_char(l_object_num);
165: ELSE

Line 501: FROM dual;

497: --
498: --create object code
499: SELECT hr_adi_object_code_s.NEXTVAL
500: INTO l_object_num
501: FROM dual;
502: l_object_code := 'GENERAL_'||to_char(l_object_num);
503: --
504: -- STEP 1. Create Integrator
505: --

Line 797: FROM dual;

793: --
794: --create object code
795: SELECT hr_adi_object_code_s.NEXTVAL
796: INTO l_object_num
797: FROM dual;
798: -- If Style is "GENERAL", prepend object code with "GENERAL_"
799: IF p_form_name = 'GENERAL' THEN
800: l_object_code := 'GENERAL_'||to_char(l_object_num);
801: ELSE

Line 1075: dual;

1071: INTO
1072: l_user_id,
1073: l_language
1074: FROM
1075: dual;
1076: -- UPPER parameters
1077: IF p_api_package_name IS NOT NULL THEN
1078: l_package_name := UPPER(p_api_package_name);
1079: END IF;