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 2003: ,fnd_profile.value('PER_BUSINESS_GROUP_ID'));

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