DBA Data[Home] [Help]

APPS.PER_RECRUIT_ACTIVITY_FOR_PKG dependencies on DUAL

Line 23: 05-Mar-97 J.Alloun 70.7 Changed all occurances of system.dual

19: 29-Jan-95 D.Kerr 70.5 Removed WHO-columns for Set8 Changes.
20: 29-Jan-95 D.Kerr 70.6 Added uniqueness checks to prevent
21: duplicate vacancies for a recruitment
22: activity G1351
23: 05-Mar-97 J.Alloun 70.7 Changed all occurances of system.dual
24: to sys.dual for next release requirements.
25: =============================================================================*/
26: -----------------------------------------------------------------------------
27: -- Name --

Line 24: to sys.dual for next release requirements.

20: 29-Jan-95 D.Kerr 70.6 Added uniqueness checks to prevent
21: duplicate vacancies for a recruitment
22: activity G1351
23: 05-Mar-97 J.Alloun 70.7 Changed all occurances of system.dual
24: to sys.dual for next release requirements.
25: =============================================================================*/
26: -----------------------------------------------------------------------------
27: -- Name --
28: -- chk_vacancy_unique

Line 122: FROM sys.dual;

118:
119:
120: CURSOR C2 IS
121: SELECT per_recruitment_activity_for_s.nextval
122: FROM sys.dual;
123:
124: BEGIN
125: --
126: -- Check that the vacancy id has not already been used for this