DBA Data[Home] [Help]

APPS.HR_CAL_ENTRY_VALUE_API dependencies on FND_PROFILE

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

493: l_sql_statement := get_sql_from_vset_id(p_vset_id => l_value_set_id);
494: --
495: l_sql_statement := REPLACE(l_sql_statement
496: ,':$PROFILES$.PER_BUSINESS_GROUP_ID'
497: ,fnd_profile.value('PER_BUSINESS_GROUP_ID'));
498:
499: --
500: l_id_column := SUBSTR(l_sql_statement,(INSTR(UPPER(l_sql_statement),'SELECT') +7)
501: ,INSTR(UPPER(l_sql_statement),',') -

Line 710: l_str := REPLACE(l_str,':$PROFILES$.PER_BUSINESS_GROUP_ID',fnd_profile.value('PER_BUSINESS_GROUP_ID'));

706: ||' from '
707: ||l_v_r.table_info.table_name||' '||l_whr;
708:
709: -- substitute the BG if required.
710: l_str := REPLACE(l_str,':$PROFILES$.PER_BUSINESS_GROUP_ID',fnd_profile.value('PER_BUSINESS_GROUP_ID'));
711: --
712: RETURN (l_str);
713: --
714: END get_sql_from_vset_id;