APPS.PER_ZA_WSP_ARCHIVE_PKG dependencies on FND_GLOBAL

Line 250: and security_group_id = fnd_global.lookup_security_group(p_lookup_type,3)

246: substr(lookup_code,5) lookup_code
247: from fnd_lookup_values
248: where lookup_type = p_lookup_type
249: and lookup_code like p_year || '%'
250: and security_group_id = fnd_global.lookup_security_group(p_lookup_type,3)
251: and attribute_category = G_ATTRIBUTE_CATEGORY
252: and (
253: Attribute1 || Attribute2 || Attribute3 || Attribute4 || Attribute5 ||
254: Attribute6 || Attribute7 || Attribute8 || Attribute9 || Attribute10 ||

Line 846: and security_group_id = fnd_global.lookup_security_group(p_lookup_type,3)

842: substr(lookup_code,5) lookup_code -- trng event id
843: from fnd_lookup_values
844: where lookup_type = p_lookup_type
845: and lookup_code like p_year || '%'
846: and security_group_id = fnd_global.lookup_security_group(p_lookup_type,3)
847: and attribute_category = G_ATTRIBUTE_CATEGORY
848: and (
849: Attribute1 || Attribute2 || Attribute3 || Attribute4 || Attribute5 ||
850: Attribute6 || Attribute7 || Attribute8 || Attribute9 || Attribute10 ||

Line 2830: hr_utility.set_location('fnd_global.conc_request_id : '||fnd_global.conc_request_id,10);

2826:
2827: --set pl/sql table
2828: hr_utility.set_location('g_pl_tab_start : '||g_pl_tab_start,10);
2829: hr_utility.set_location('g_pl_tab_end : '||g_pl_tab_end,10);
2830: hr_utility.set_location('fnd_global.conc_request_id : '||fnd_global.conc_request_id,10);
2831:
2832: if g_pl_tab_start <> 'Y' and g_pl_tab_end <> 'Y' then
2833: set_global_tables;
2834: end if;