APPS.HR_ADE_ADI_DATA_SETUP dependencies on DUAL

Line 166: FROM dual;

162: --
163: --create object code
164: SELECT hr_adi_object_code_s.NEXTVAL
165: INTO l_object_num
166: FROM dual;
167: -- If Style is "GENERAL", prepend object code with "GENERAL_"
168: IF p_form_name = 'GENERAL' THEN
169: l_object_code := 'GENERAL_'||to_char(l_object_num);
170: ELSE

Line 536: FROM dual;

532: --
533: --create object code
534: SELECT hr_adi_object_code_s.NEXTVAL
535: INTO l_object_num
536: FROM dual;
537: l_object_code := 'GENERAL_'||to_char(l_object_num);
538: --
539: -- STEP 1. Create Integrator
540: --

Line 832: FROM dual;

828: --
829: --create object code
830: SELECT hr_adi_object_code_s.NEXTVAL
831: INTO l_object_num
832: FROM dual;
833: -- If Style is "GENERAL", prepend object code with "GENERAL_"
834: IF p_form_name = 'GENERAL' THEN
835: l_object_code := 'GENERAL_'||to_char(l_object_num);
836: ELSE

Line 1110: dual;

1106: INTO
1107: l_user_id,
1108: l_language
1109: FROM
1110: dual;
1111: -- UPPER parameters
1112: IF p_api_package_name IS NOT NULL THEN
1113: l_package_name := UPPER(p_api_package_name);
1114: END IF;