APPS.CSM_PROFILE_EVENT_PKG dependencies on FND_PROFILE_OPTIONS

Line 18: WHERE NOT EXISTS( SELECT 1 FROM FND_PROFILE_OPTIONS OPT

14: AND acc.level_value = val.level_value
15: AND (acc.level_id <> 10003 OR acc.level_value_application_id=val.level_value_application_id))
16: UNION
17: SELECT access_id,user_id FROM csm_profile_option_values_acc ACC
18: WHERE NOT EXISTS( SELECT 1 FROM FND_PROFILE_OPTIONS OPT
19: WHERE OPT.PROFILE_OPTION_ID = ACC.PROFILE_OPTION_ID
20: AND OPT.APPLICATION_ID = ACC.APPLICATION_ID
21: AND NVL(OPT.start_date_active, SYSDATE) <= SYSDATE
22: AND NVL(OPT.end_date_active, SYSDATE) >= SYSDATE

Line 136: FROM fnd_profile_options opt,

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
139: WHERE opt.profile_option_name in ( 'CSF_M_RECIPIENTS_BOUNDARY' ,'CSF_MOBILE_TASK_TIMES_UPDATABLE' ,'CSF_DEBRIEF_OVERLAPPING_LABOR' ,'INC_DEFAULT_INCIDENT_SEVERITY'
140: ,'INC_DEFAULT_INCIDENT_URGENCY' ,'JTF_TIME_UOM_CLASS' ,'ICX_PREFERRED_CURRENCY' ,'JTF_TASK_DEFAULT_ASSIGNEE_STATUS' ,'CS_SR_RESTRICT_IB' ,'SERVER_TIMEZONE_ID'

Line 376: FROM fnd_profile_options opt,

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
379: WHERE opt.profile_option_name in ( 'CSF_M_RECIPIENTS_BOUNDARY' ,'CSF_MOBILE_TASK_TIMES_UPDATABLE' ,'CSF_DEBRIEF_OVERLAPPING_LABOR'
380: ,'INC_DEFAULT_INCIDENT_SEVERITY' ,'INC_DEFAULT_INCIDENT_URGENCY'

Line 493: FROM fnd_profile_options opt,asg_user au

489: IF PROFILES with no "value" set, is required, then add this inside "tab" of insert cursor */
490: /*
491: UNION ALL
492: SELECT opt.profile_option_name,opt.application_id, opt.profile_option_id,au.user_id,null as LEVEL_ID , null LEVEL_VALUE, null LEVEL_VALUE_APPLICATION_ID
493: FROM fnd_profile_options opt,asg_user au
494: WHERE opt.profile_option_name in ( 'CSF_M_RECIPIENTS_BOUNDARY' ,'CSF_MOBILE_TASK_TIMES_UPDATABLE' ,'CSF_DEBRIEF_OVERLAPPING_LABOR'
495: ,'INC_DEFAULT_INCIDENT_SEVERITY' ,'INC_DEFAULT_INCIDENT_URGENCY'
496: ,'JTF_TIME_UOM_CLASS' ,'ICX_PREFERRED_CURRENCY' ,'JTF_TASK_DEFAULT_ASSIGNEE_STATUS' ,'CS_SR_RESTRICT_IB' ,'SERVER_TIMEZONE_ID'
497: ,'CLIENT_TIMEZONE_ID' ,'CSF_BUSINESS_PROCESS'

Line 532: FROM fnd_profile_options opt,asg_user au

528: ******/
529: /*
530: SELECT csm_profiles_acc_s.NEXTVAL as ACCESS_ID,au.user_id,opt.profile_option_name,opt.application_id, opt.profile_option_id,au.user_id,
531: null as LEVEL_ID , null LEVEL_VALUE, null LEVEL_VALUE_APPLICATION_ID,opt.profile_option_name
532: FROM fnd_profile_options opt,asg_user au
533: WHERE opt.profile_option_name in ( 'CSF_M_RECIPIENTS_BOUNDARY' ,'CSF_MOBILE_TASK_TIMES_UPDATABLE' ,'CSF_DEBRIEF_OVERLAPPING_LABOR'
534: ,'INC_DEFAULT_INCIDENT_SEVERITY' ,'INC_DEFAULT_INCIDENT_URGENCY'
535: ,'JTF_TIME_UOM_CLASS' ,'ICX_PREFERRED_CURRENCY' ,'JTF_TASK_DEFAULT_ASSIGNEE_STATUS' ,'CS_SR_RESTRICT_IB' ,'SERVER_TIMEZONE_ID'
536: ,'CLIENT_TIMEZONE_ID' ,'CSF_BUSINESS_PROCESS'