APPS.PER_SECONDARY_ASS_STATUSES_PKG dependencies on DUAL

Line 20: 05-Mar-97 JAlloun 70.6 Changed all occurances of system.dual to

16: Date Author Version Description
17: --------- ---------- ------ ----------------------------------
18: 18-Apr-93 JRhodes 80.1 Changed Lock-Row to rtrim varchar2 columns
19: 27-Jan-95 JRhodes 70.5 Removed AOL WHO Columns
20: 05-Mar-97 JAlloun 70.6 Changed all occurances of system.dual to
21: sys.dual for next release requirements.
22: -----------------------------------------------------------------------------*/
23:
24: procedure check_unique_row(p_assignment_id number

Line 21: sys.dual for next release requirements.

17: --------- ---------- ------ ----------------------------------
18: 18-Apr-93 JRhodes 80.1 Changed Lock-Row to rtrim varchar2 columns
19: 27-Jan-95 JRhodes 70.5 Removed AOL WHO Columns
20: 05-Mar-97 JAlloun 70.6 Changed all occurances of system.dual to
21: sys.dual for next release requirements.
22: -----------------------------------------------------------------------------*/
23:
24: procedure check_unique_row(p_assignment_id number
25: ,p_assignment_status_type_id number

Line 73: CURSOR C2 IS SELECT per_secondary_ass_statuses_s.nextval FROM sys.dual;

69: ) IS
70: CURSOR C IS SELECT rowid FROM PER_SECONDARY_ASS_STATUSES
71: WHERE secondary_ass_status_id = X_Secondary_Ass_Status_Id;
72:
73: CURSOR C2 IS SELECT per_secondary_ass_statuses_s.nextval FROM sys.dual;
74: BEGIN
75: --
76: check_unique_row(X_Assignment_Id
77: ,X_Assignment_Status_Type_Id