APPS.PER_APPLICATIONS_PKG dependencies on PER_APPLICATIONS_S

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