APPS.PER_CANCEL_HIRE_OR_APL_PKG dependencies on PER_SECONDARY_ASS_STATUSES

Line 3237: from per_secondary_ass_statuses sas

3233: -- secondary assignment statuses cursor
3234: --
3235: cursor sec_asg_statuses2(p_assignment_id NUMBER) is
3236: select sas.rowid
3237: from per_secondary_ass_statuses sas
3238: where sas.assignment_id = p_assignment_id;
3239: --
3240: -- assignment extra info cursor
3241: --

Line 3498: per_secondary_ass_statuses_pkg.delete_row(l_rowid);

3494: <>
3495: loop
3496: fetch sec_asg_statuses2 into l_rowid;
3497: exit when sec_asg_statuses2%NOTFOUND;
3498: per_secondary_ass_statuses_pkg.delete_row(l_rowid);
3499: end loop sec_asg_statuses;
3500: close sec_asg_statuses2;
3501: --
3502: --