APPS.PAY_US_DB_PER_SETUP dependencies on DUAL

Line 130: FROM sys.dual ;

126: hr_utility.set_location('pay_us_db_per_setup.insert_organization_unit',1);
127: --
128: SELECT hr_organization_units_s.nextval
129: INTO l_organization_id
130: FROM sys.dual ;
131: --
132: hr_organization.unique_name(p_business_group_id,l_organization_id,p_name);
133: --
134: --

Line 173: FROM sys.dual ;

169: ,0
170: ,0
171: ,0
172: ,SYSDATE
173: FROM sys.dual ;
174: --
175: hr_utility.set_location('pay_us_db_per_setup.insert_organization_unit',3);
176: --
177: OPEN get_languages;

Line 204: FROM sys.dual ;

200: ,0
201: ,0
202: ,0
203: ,SYSDATE
204: FROM sys.dual ;
205: --
206: END LOOP;
207: --
208: hr_utility.set_location('pay_us_db_per_setup.insert_organization_unit',4);

Line 1228: FROM sys.dual;

1224: begin
1225: --
1226: SELECT per_org_structure_versions_s.nextval
1227: INTO l_organization_structure_id
1228: FROM sys.dual;
1229: --
1230: INSERT INTO per_organization_structures
1231: (organization_structure_id
1232: ,business_group_id

Line 1262: FROM sys.dual;

1258: --
1259: --
1260: SELECT per_org_structure_versions_s.nextval
1261: INTO l_org_structure_version_id
1262: FROM sys.dual;
1263: --
1264: --
1265: INSERT INTO per_org_structure_versions
1266: (org_structure_version_id

Line 1452: FROM sys.dual;

1448: hr_utility.set_location('pay_us_db_per_setup.insert_job_definition',1);
1449: --
1450: SELECT per_job_definitions_s.nextval
1451: INTO l_job_definition_id
1452: FROM sys.dual;
1453: --
1454: hr_utility.set_location('pay_us_db_per_setup.insert_job_definition',2);
1455: --
1456: INSERT INTO per_job_definitions

Line 1548: FROM sys.dual;

1544: hr_utility.set_location('pay_us_db_per_setup.insert_job',1);
1545: --
1546: SELECT per_jobs_s.nextval
1547: INTO l_job_id
1548: FROM sys.dual;
1549: --
1550: hr_utility.set_location('pay_us_db_per_setup.insert_job',2);
1551: --
1552: unique_name(l_business_group_id,l_job_id, p_name);

Line 1728: FROM sys.dual;

1724: hr_utility.set_location('pay_us_db_per_setup.insert_pos_definition',1);
1725: --
1726: SELECT per_position_definitions_s.nextval
1727: INTO l_pos_definition_id
1728: FROM sys.dual;
1729: --
1730: hr_utility.set_location('pay_us_db_per_setup.insert_pos_definition',2);
1731: --
1732: INSERT INTO per_position_definitions

Line 1824: FROM sys.dual;

1820: hr_utility.set_location('pay_us_db_per_setup.insert_position',1);
1821: --
1822: SELECT per_positions_s.nextval
1823: INTO l_position_id
1824: FROM sys.dual;
1825: --
1826: hr_utility.set_location('pay_us_db_per_setup.insert_position',2);
1827: --
1828: unique_name(l_business_group_id, l_position_id, p_name);

Line 2051: FROM sys.dual;

2047: hr_utility.set_location('pay_us_db_per_setup.insert_grade_definition',1);
2048: --
2049: SELECT per_grade_definitions_s.nextval
2050: INTO l_grade_definition_id
2051: FROM sys.dual;
2052: --
2053: hr_utility.set_location('pay_us_db_per_setup.insert_grade_definition',2);
2054: --
2055: INSERT INTO per_grade_definitions

Line 2147: FROM sys.dual;

2143: hr_utility.set_location('pay_us_db_per_setup.insert_grade',1);
2144: --
2145: SELECT per_grades_s.nextval
2146: INTO l_grade_id
2147: FROM sys.dual;
2148: --
2149: hr_utility.set_location('pay_us_db_per_setup.insert_grade',2);
2150: --
2151: unique_name(l_business_group_id, l_grade_id, p_name);

Line 2232: FROM DUAL;

2228: hr_utility.set_location('scltstdat.insert_wc_fund',1);
2229: --
2230: SELECT PAY_WC_FUNDS_S.NEXTVAL
2231: INTO l_fund_id
2232: FROM DUAL;
2233: --
2234: hr_utility.set_location('scltstdat.insert_wc_fund',5);
2235: --
2236: IF (SQL%NOTFOUND) THEN

Line 2271: FROM DUAL;

2267: hr_utility.set_location('scltstdat.insert_wc_rate',1);
2268: --
2269: SELECT PAY_WC_RATES_S.NEXTVAL
2270: INTO l_wc_code
2271: FROM DUAL;
2272: --
2273: hr_utility.set_location('scltstdat.insert_wc_rate',5);
2274: --
2275: IF (SQL%NOTFOUND) THEN

Line 2333: from sys.dual;

2329: hr_utility.set_location('scltstdat.create_us_location',1);
2330: --
2331: select hr_locations_s.nextval
2332: into l_location_id
2333: from sys.dual;
2334: --
2335: hr_utility.set_location('scltstdat.create_us_location',5);
2336: --
2337: INSERT INTO hr_locations