APPS.PER_CANCEL_HIRE_OR_APL_PKG dependencies on PER_SECONDARY_ASS_STATUSES

Line 2237: from per_secondary_ass_statuses sas

2233: -- secondary assignment statuses cursor
2234: --
2235: cursor sec_asg_statuses2(p_assignment_id NUMBER) is
2236: select sas.rowid
2237: from per_secondary_ass_statuses sas
2238: where sas.assignment_id = p_assignment_id;
2239: --
2240: -- assignment extra info cursor
2241: --

Line 2434: per_secondary_ass_statuses_pkg.delete_row(l_rowid);

2430: <>
2431: loop
2432: fetch sec_asg_statuses2 into l_rowid;
2433: exit when sec_asg_statuses2%NOTFOUND;
2434: per_secondary_ass_statuses_pkg.delete_row(l_rowid);
2435: end loop sec_asg_statuses;
2436: close sec_asg_statuses2;
2437: --
2438: --