eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IRC_UTILITIES_PKG dependencies on FND_PROFILE

Line 1940: where BUSINESS_GROUP_ID = fnd_profile.value('IRC_CORPORATE_BUSINESS_GROUP');

1936: l_profile_date varchar2(240);
1937: cursor csr_corp_currency is
1938: select CURRENCY_CODE
1939: from per_business_groups
1940: where BUSINESS_GROUP_ID = fnd_profile.value('IRC_CORPORATE_BUSINESS_GROUP');
1941: begin
1942: --
1943: if(to_currency is null) then
1944: open csr_corp_currency;

Line 1952: select nvl(fnd_profile.value('IRC_CURR_CONV_DATE'),'') into l_profile_date

1948: end if;
1949: end if;
1950: --
1951: if(exchange_date is null) then
1952: select nvl(fnd_profile.value('IRC_CURR_CONV_DATE'),'') into l_profile_date
1953: from dual;
1954: exchange_date := get_exchange_date(l_profile_date,to_currency);
1955: end if;
1956:

Line 1978: where BUSINESS_GROUP_ID = fnd_profile.value('IRC_CORPORATE_BUSINESS_GROUP');

1974: l_to_currency varchar2(240);
1975: cursor csr_curr_code is
1976: select CURRENCY_CODE
1977: from per_business_groups
1978: where BUSINESS_GROUP_ID = fnd_profile.value('IRC_CORPORATE_BUSINESS_GROUP');
1979: begin
1980: l_user_date := to_date(profile_date||'-'||to_char(effective_date,'YYYY'),'dd-MM-YYYY');
1981: if(l_user_date > effective_date) then
1982: l_user_date := to_date(profile_date||'-'||to_char(to_number(to_char(effective_date,'YYYY'))-1),'dd-MM-YYYY');

Line 2036: AND END_USER_COLUMN_NAME = fnd_profile.value('IRC_OFFER_SAL_FLEX_SEGMENT');

2032: SELECT APPLICATION_COLUMN_NAME
2033: FROM FND_DESCR_FLEX_COLUMN_USAGES
2034: WHERE DESCRIPTIVE_FLEXFIELD_NAME = (dff_name)
2035: and DESCRIPTIVE_FLEX_CONTEXT_CODE = 'Global Data Elements'
2036: AND END_USER_COLUMN_NAME = fnd_profile.value('IRC_OFFER_SAL_FLEX_SEGMENT');
2037:
2038: return_val VARCHAR2(24);
2039: query_stmt VARCHAR2(2000);
2040: l_column_name VARCHAR2(240);

Line 2175: AND END_USER_COLUMN_NAME = fnd_profile.value('IRC_OFFER_SAL_FLEX_SEGMENT');

2171: SELECT APPLICATION_COLUMN_NAME
2172: FROM FND_DESCR_FLEX_COLUMN_USAGES
2173: WHERE DESCRIPTIVE_FLEXFIELD_NAME = 'PER_PAY_BASES'
2174: and DESCRIPTIVE_FLEX_CONTEXT_CODE = 'Global Data Elements'
2175: AND END_USER_COLUMN_NAME = fnd_profile.value('IRC_OFFER_SAL_FLEX_SEGMENT');
2176: Begin
2177: IF(p_salary_basis_id IS NOT NULL) THEN
2178: SELECT name
2179: INTO l_salary_basis_name