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 120: FROM fnd_lookup_values val,

116: val.lookup_code,
117: val.security_group_id,
118: val.language,
119: val.last_update_date
120: FROM fnd_lookup_values val,
121: csm_lookups_acc acc
122: WHERE acc.lookup_type = val.lookup_type
123: AND acc.language = val.language
124: AND acc.lookup_code = val.lookup_code

Line 143: FROM fnd_lookup_values val

139: acc.last_update_date
140: FROM csm_lookups_acc acc
141: WHERE NOT EXISTS
142: (SELECT 1
143: FROM fnd_lookup_values val
144: WHERE acc.lookup_type = val.lookup_type
145: AND acc.language = val.language
146: AND acc.lookup_code = val.lookup_code
147: AND acc.security_group_id = val.security_group_id