DBA Data[Home] [Help]

APPS.PER_PERSON_TYPES_PKG dependencies on DUAL

Line 99: CURSOR C2 IS SELECT per_person_types_s.nextval FROM sys.dual;

95: ) IS
96: CURSOR C IS SELECT rowid FROM per_person_types
97: WHERE person_type_id = X_Person_Type_Id;
98:
99: CURSOR C2 IS SELECT per_person_types_s.nextval FROM sys.dual;
100:
101: BEGIN
102:
103: if (X_Person_Type_Id is NULL) then

Line 519: from dual

515: -- modified the cursor definition for better performance
516: -- Bug #3646157
517: cursor csr_system is
518: select null
519: from dual
520: where exists (
521: (select null
522: from per_people_f
523: where person_type_id = X_person_type_id)