APPS.PER_ZA_WSP_ARCHIVE_PKG dependencies on FND_GLOBAL

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

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

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

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

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

2820:
2821: --set pl/sql table
2822: hr_utility.set_location('g_pl_tab_start : '||g_pl_tab_start,10);
2823: hr_utility.set_location('g_pl_tab_end : '||g_pl_tab_end,10);
2824: hr_utility.set_location('fnd_global.conc_request_id : '||fnd_global.conc_request_id,10);
2825:
2826: if g_pl_tab_start <> 'Y' and g_pl_tab_end <> 'Y' then
2827: set_global_tables;
2828: end if;