APPS.CSF_SKILLS_PKG dependencies on DUAL

Line 203: from dual;

199: if x_skill_type_id is null
200: then
201: select csf_skill_types_b_s1.nextval
202: into x_skill_type_id
203: from dual;
204: else
205: -- Checks if record to be inserted already exists.
206: -- If it does, do nothing (RETURN), else, continue.
207: open c_rowid;

Line 675: from dual;

671: if x_skill_id is null
672: then
673: select csf_skills_b_s1.nextval
674: into x_skill_id
675: from dual;
676: else
677: -- Checks if record to be inserted already exists.
678: -- If it does, do nothing (RETURN), else, continue.
679: open c_rowid;

Line 1091: from dual;

1087: if x_rating_scale_id is null
1088: then
1089: select csf_rating_scales_b_s1.nextval
1090: into x_rating_scale_id
1091: from dual;
1092: else
1093: -- Checks if record to be inserted already exists.
1094: -- If it does, do nothing (RETURN), else, continue.
1095: open c_rowid;

Line 1519: from dual;

1515: if x_skill_level_id is null
1516: then
1517: select csf_skill_levels_b_s1.nextval
1518: into x_skill_level_id
1519: from dual;
1520: else
1521: -- Checks if record to be inserted already exists.
1522: -- If it does, do nothing (RETURN), else, continue.
1523: open c_rowid;

Line 1983: from dual;

1979: if x_resource_skill_id is null
1980: then
1981: select csf_resource_skills_b_s1.nextval
1982: into x_resource_skill_id
1983: from dual;
1984: else
1985: -- Checks if record to be inserted already exists.
1986: -- If it does, do nothing (RETURN), else, continue.
1987: open c_rowid;

Line 2274: from dual;

2270: if x_required_skill_id is null
2271: then
2272: select csf_required_skills_b_s1.nextval
2273: into x_required_skill_id
2274: from dual;
2275: else
2276: -- Checks if record to be inserted already exists.
2277: -- If it does, do nothing (RETURN), else, continue.
2278: open c_rowid;