APPS.CSM_PROFILE_EVENT_PKG dependencies on CSM_PROFILES_ACC_S

Line 112: SELECT csm_profiles_acc_s.NEXTVAL as ACCESS_ID, au.user_id ,

108: THAT PROFILE TO C_PURGE CURSOR WHICH WILL OTHERWISE REMOVE IT*/
109: --Cursor to insert all profiles(without profile value)
110: CURSOR l_profiles_wovalue_ins_csr
111: IS
112: SELECT csm_profiles_acc_s.NEXTVAL as ACCESS_ID, au.user_id ,
113: opt.profile_option_id, opt.application_id
114: FROM fnd_profile_options opt,
115: ASG_USER au
116: WHERE (opt.profile_option_name = 'CSF_M_RECIPIENTS_BOUNDARY'

Line 564: SELECT csm_profiles_acc_s.NEXTVAL

560: from ASG_USER
561: where USER_ID = c_user_id;
562:
563: CURSOR c_profile_seq IS
564: SELECT csm_profiles_acc_s.NEXTVAL
565: FROM dual;
566:
567: l_csm_appl_id fnd_application.application_id%TYPE;
568: l_csm_resp_id fnd_responsibility.responsibility_id%TYPE;

Line 978: SELECT csm_profiles_acc_s.NEXTVAL

974: FROM asg_user
975: WHERE user_id = c_user_id;
976:
977: CURSOR c_profile_seq IS
978: SELECT csm_profiles_acc_s.NEXTVAL
979: FROM dual;
980:
981: l_csm_appl_id fnd_application.application_id%TYPE;
982: l_csm_resp_id fnd_responsibility.responsibility_id%TYPE;