APPS.PQH_GENERIC_HIERARCHY_PACKAGE dependencies on FND_PROFILE

Line 441: l_str := REPLACE(l_str,':$PROFILES$.PER_BUSINESS_GROUP_ID',fnd_profile.value('

437: ||l_v_r.table_info.value_column_name ||' Nodename from '
438: ||l_v_r.table_info.table_name ||' '||l_whr);
439:
440: -- substitute the BG if required.
441: l_str := REPLACE(l_str,':$PROFILES$.PER_BUSINESS_GROUP_ID',fnd_profile.value('
442: PER_BUSINESS_GROUP_ID'));
443: --
444: if g_debug then
445: hr_utility.set_location('Leaving:'||l_proc, 20);

Line 2004: ,fnd_profile.value('PER_BUSINESS_GROUP_ID'));

2000: l_sql_statement := l_sql_statement||' where '||l_id_column||' = :id ';
2001: end if;
2002: --
2003: l_sql_statement := REPLACE(l_sql_statement,':$PROFILES$.PER_BUSINESS_GROUP_ID'
2004: ,fnd_profile.value('PER_BUSINESS_GROUP_ID'));
2005: --
2006: if g_debug then
2007: hr_utility.set_location('Value Set Sql Retrieved and Processed', 30);
2008: end if;