DBA Data[Home] [Help]

APPS.CSM_LOOKUP_EVENT_PKG dependencies on FND_LOOKUP_VALUES

Line 57: FROM fnd_lookup_values val

53: val.lookup_code,
54: val.security_group_id,
55: val.language,
56: val.last_update_date
57: FROM fnd_lookup_values val
58: WHERE enabled_flag = 'Y'
59: AND (
60: (val.view_application_id = 0 AND val.lookup_type = 'JTF_RS_RESOURCE_TYPES' AND val.lookup_code IN ('RS_EMPLOYEE','RS_GROUP'))
61: OR

Line 109: FROM fnd_lookup_values val,

105: val.lookup_code,
106: val.security_group_id,
107: val.language,
108: val.last_update_date
109: FROM fnd_lookup_values val,
110: csm_lookups_acc acc
111: WHERE acc.lookup_type = val.lookup_type
112: AND acc.language = val.language
113: AND acc.lookup_code = val.lookup_code

Line 132: FROM fnd_lookup_values val

128: acc.last_update_date
129: FROM csm_lookups_acc acc
130: WHERE NOT EXISTS
131: (SELECT 1
132: FROM fnd_lookup_values val
133: WHERE acc.lookup_type = val.lookup_type
134: AND acc.language = val.language
135: AND acc.lookup_code = val.lookup_code
136: AND acc.security_group_id = val.security_group_id