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 2066: CURSOR C2 IS SELECT per_applications_s.nextval FROM sys.dual;

2062: p_Creation_Date DATE
2063: ) IS
2064: CURSOR C IS SELECT rowid FROM PER_APPLICATIONS
2065: WHERE application_id = p_Application_Id;
2066: CURSOR C2 IS SELECT per_applications_s.nextval FROM sys.dual;
2067: BEGIN
2068: if (p_Application_Id is NULL) then
2069: OPEN C2;
2070: FETCH C2 INTO p_Application_Id;

Line 2557: SELECT per_applications_s.nextval into l_new_application_id FROM sys.dual;

2553: open chk_apl_exists(asg_rec.effective_start_date);
2554: fetch chk_apl_exists into l_current_apl_id,l_current_apl_end_date;
2555: if chk_apl_exists%notfound then
2556:
2557: SELECT per_applications_s.nextval into l_new_application_id FROM sys.dual;
2558: l_current_apl_id := l_new_application_id;
2559: hr_utility.set_location('Creating a new APL with ID : '||l_new_application_id,15);
2560: begin
2561: -- If there is no APL, creating the new APL