DBA Data[Home] [Help]

APPS.PER_VACANCIES_PKG dependencies on DUAL

Line 44: 05-MAR-97 J.Alloun 70.10 Changed all occurances of system.dual

40: 2. Added check to per_assignments
41: to check_references and call
42: this procedure from delete_row.
43:
44: 05-MAR-97 J.Alloun 70.10 Changed all occurances of system.dual
45: to sys.dual for next release requirements.
46:
47: 26-JAN-98 I.Harding 110.2 Added vacancy_category parameter to
48: insert, update and lock procs.

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

41: to check_references and call
42: this procedure from delete_row.
43:
44: 05-MAR-97 J.Alloun 70.10 Changed all occurances of system.dual
45: to sys.dual for next release requirements.
46:
47: 26-JAN-98 I.Harding 110.2 Added vacancy_category parameter to
48: insert, update and lock procs.
49:

Line 860: FROM sys.dual;

856: WHERE vacancy_id = X_Vacancy_Id;
857:
858:
859: CURSOR C2 IS SELECT per_vacancies_s.nextval
860: FROM sys.dual;
861: BEGIN
862:
863: if (X_Vacancy_Id is NULL) then
864: OPEN C2;