APPS.PER_DB_PER_SETUP dependencies on DUAL

Line 124: FROM sys.dual ;

120: hr_utility.set_location('per_db_per_setup.insert_organization_unit',1);
121: --
122: SELECT hr_organization_units_s.nextval
123: INTO l_organization_id
124: FROM sys.dual ;
125: --
126: hr_organization.unique_name(p_business_group_id,l_organization_id,p_name);
127: --
128: --

Line 168: FROM sys.dual ;

164: ,0
165: ,0
166: ,0
167: ,SYSDATE
168: FROM sys.dual ;
169: --
170: OPEN get_languages;
171: --
172: LOOP

Line 197: FROM sys.dual ;

193: ,0
194: ,0
195: ,0
196: ,SYSDATE
197: FROM sys.dual ;
198: --
199: END LOOP;
200: --
201: --

Line 316: FROM sys.dual;

312: --
313: hr_utility.set_location('per_db_per_setup.insert_org_information',20);
314: SELECT hr_organization_information_s.nextval
315: INTO l_org_information_id
316: FROM sys.dual;
317: --
318: hr_utility.set_location('per_db_per_setup.insert_org_information',25);
319: INSERT INTO HR_ORGANIZATION_INFORMATION
320: (org_information_id

Line 890: FROM sys.dual;

886: hr_utility.set_location('per_db_per_setup.insert_job_definition',1);
887: --
888: SELECT per_job_definitions_s.nextval
889: INTO l_job_definition_id
890: FROM sys.dual;
891: --
892: hr_utility.set_location('per_db_per_setup.insert_job_definition',2);
893: --
894: INSERT INTO per_job_definitions

Line 986: FROM sys.dual;

982: hr_utility.set_location('per_db_per_setup.insert_job',1);
983: --
984: SELECT per_jobs_s.nextval
985: INTO l_job_id
986: FROM sys.dual;
987: --
988: hr_utility.set_location('per_db_per_setup.insert_job',2);
989: --
990: unique_name(l_business_group_id,l_job_id, p_name);

Line 1169: FROM sys.dual;

1165: hr_utility.set_location('per_db_per_setup.insert_pos_definition',1);
1166: --
1167: SELECT per_position_definitions_s.nextval
1168: INTO l_pos_definition_id
1169: FROM sys.dual;
1170: --
1171: hr_utility.set_location('per_db_per_setup.insert_pos_definition',2);
1172: --
1173: INSERT INTO per_position_definitions

Line 1267: -- FROM sys.dual;

1263: -- Changed 05-Oct-99 SCNair change insert as an API call
1264: --
1265: -- SELECT per_positions_s.nextval
1266: -- INTO l_position_id
1267: -- FROM sys.dual;
1268: --
1269: hr_utility.set_location('per_db_per_setup.insert_position',2);
1270: --
1271: unique_name(l_business_group_id, l_position_id, p_name);

Line 1589: FROM sys.dual;

1585: hr_utility.set_location('per_db_per_setup.insert_grade_definition',1);
1586: --
1587: SELECT per_grade_definitions_s.nextval
1588: INTO l_grade_definition_id
1589: FROM sys.dual;
1590: --
1591: hr_utility.set_location('per_db_per_setup.insert_grade_definition',2);
1592: --
1593: INSERT INTO per_grade_definitions

Line 1685: FROM sys.dual;

1681: hr_utility.set_location('per_db_per_setup.insert_grade',1);
1682: --
1683: SELECT per_grades_s.nextval
1684: INTO l_grade_id
1685: FROM sys.dual;
1686: --
1687: hr_utility.set_location('per_db_per_setup.insert_grade',2);
1688: --
1689: unique_name(l_business_group_id, l_grade_id, p_name);