APPS.CSM_PROFILE_EVENT_PKG dependencies on ASG_BASE

Line 134: decode(max(val.level_id),10004,au.user_id,10003,asg_base.get_resp_id(au.user_name),10002,asg_base.get_application_id(au.user_name),0) LEVEL_VALUE,

130: SELECT csm_profiles_acc_s.NEXTVAL as ACCESS_ID,au.user_id,application_id,profile_option_id,level_id,level_value,LEVEL_VALUE_APPLICATION_ID,
131: fnd_profile.value_specific(profile_option_name,au.user_id,au.responsibility_id,au.APP_ID) PRF_VALUE,profile_option_name prf_name
132: FROM asg_user au,
133: (SELECT opt.profile_option_name,val.application_id, val.profile_option_id,au.user_id,max(val.level_id) as LEVEL_ID ,
134: decode(max(val.level_id),10004,au.user_id,10003,asg_base.get_resp_id(au.user_name),10002,asg_base.get_application_id(au.user_name),0) LEVEL_VALUE,
135: decode(max(val.level_id),10003,max(level_value_application_id),null) LEVEL_VALUE_APPLICATION_ID
136: FROM fnd_profile_options opt,
137: fnd_profile_option_values val,
138: asg_user au

Line 374: decode(max(val.level_id),10004,au.user_id,10003,asg_base.get_resp_id(au.user_name),10002,asg_base.get_application_id(au.user_name),0) LEVEL_VALUE,

370: SELECT csm_profiles_acc_s.NEXTVAL as ACCESS_ID,au.user_id,application_id,profile_option_id,level_id,level_value,LEVEL_VALUE_APPLICATION_ID,
371: fnd_profile.value_specific(profile_option_name,au.user_id,au.responsibility_id,au.APP_ID) PRF_VALUE,profile_option_name prf_name
372: FROM asg_user au,
373: (SELECT opt.profile_option_name,val.application_id, val.profile_option_id,au.user_id,max(val.level_id) as LEVEL_ID ,
374: decode(max(val.level_id),10004,au.user_id,10003,asg_base.get_resp_id(au.user_name),10002,asg_base.get_application_id(au.user_name),0) LEVEL_VALUE,
375: decode(max(val.level_id),10003,max(level_value_application_id),null) LEVEL_VALUE_APPLICATION_ID
376: FROM fnd_profile_options opt,
377: fnd_profile_option_values val,
378: asg_user au