APPS.CN_SEC_PROF_ASSIGNS_PKG dependencies on CN_SEC_PROF_ASSIGNS_S

Line 18: SELECT cn_sec_prof_assigns_s.NEXTVAL

14: -- 28-Jul-99 Yonghong Mao Created
15:
16: PROCEDURE get_sec_prof_assign_id(x_sec_prof_assign_id IN OUT NUMBER) IS
17: BEGIN
18: SELECT cn_sec_prof_assigns_s.NEXTVAL
19: INTO x_sec_prof_assign_id
20: FROM dual;
21: END get_sec_prof_assign_id;
22:

Line 308: UPDATE cn_sec_prof_assigns SET

304: rec.last_update_date,
305: rec.last_updated_by
306: FROM dual;
307:
308: UPDATE cn_sec_prof_assigns SET
309: security_profile_id = rec.security_profile_id,
310: salesrep_id = rec.salesrep_id,
311: start_date = rec.start_date,
312: end_date = rec.end_date,