APPS.PER_APPLICATIONS_PKG dependencies on DUAL

Line 113: from sys.dual

109: BEGIN
110:
111: select 'Y'
112: into p_del_flag
113: from sys.dual
114: where exists (
115: Select null
116: from PER_ALL_ASSIGNMENTS_F paa, per_assignment_budget_values_f abv
117: where paa.APPLICATION_ID = p_application_id

Line 161: from sys.dual

157: BEGIN
158:
159: select 'Y'
160: into p_del_flag
161: from sys.dual
162: where exists (
163: Select null
164: from PER_ALL_ASSIGNMENTS_F paa, per_assignment_budget_values_f abv
165: where paa.APPLICATION_ID = p_application_id

Line 288: from sys.dual

284: BEGIN
285:
286: select 'Y'
287: into p_del_flag
288: from sys.dual
289: where exists (
290: Select null
291: from PER_ALL_ASSIGNMENTS_F paa
292: where paa.APPLICATION_ID = p_application_id

Line 667: from sys.dual;

663: , p_last_updated_by
664: , p_last_update_login
665: , p_last_updated_by
666: , trunc(SYSDATE)
667: from sys.dual;
668: END LOOP;
669: CLOSE csr_letter_type;
670: --
671: OPEN csr_assign;

Line 1929: CURSOR C2 IS SELECT per_applications_s.nextval FROM sys.dual;

1925: p_Creation_Date DATE
1926: ) IS
1927: CURSOR C IS SELECT rowid FROM PER_APPLICATIONS
1928: WHERE application_id = p_Application_Id;
1929: CURSOR C2 IS SELECT per_applications_s.nextval FROM sys.dual;
1930: BEGIN
1931: if (p_Application_Id is NULL) then
1932: OPEN C2;
1933: FETCH C2 INTO p_Application_Id;