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.ARI_SELF_REGISTRATION_PKG dependencies on FND_PROFILE_OPTION_VALUES

Line 2899: from fnd_profile_option_values fpov, fnd_profile_options fpo

2895: IF p_user_id IS NOT NULL THEN
2896: BEGIN
2897: select fpov.profile_option_value
2898: into l_reg_sec_profile
2899: from fnd_profile_option_values fpov, fnd_profile_options fpo
2900: where fpov.profile_option_id = fpo.profile_option_id
2901: and fpo.profile_option_name like 'XLA_MO_SECURITY_PROFILE_LEVEL'
2902: and fpov.level_id = 10004 -- user level
2903: and fpov.level_value = p_user_id;

Line 2919: from fnd_profile_option_values fpov, fnd_profile_options fpo

2915: --Get the security profile value set up for the
2916: --iReceivables Registration responsibility
2917: select fpov.profile_option_value
2918: into l_reg_sec_profile
2919: from fnd_profile_option_values fpov, fnd_profile_options fpo
2920: where fpov.profile_option_id = fpo.profile_option_id
2921: and fpo.profile_option_name like 'XLA_MO_SECURITY_PROFILE_LEVEL'
2922: and fpov.level_id = 10003 -- responsibility level
2923: and fpov.level_value_application_id = 222

Line 2930: from fnd_profile_option_values fpov, fnd_profile_options fpo

2926: WHEN NO_DATA_FOUND THEN
2927: --Get the security profile set up at the site level
2928: select fpov.profile_option_value
2929: into l_reg_sec_profile
2930: from fnd_profile_option_values fpov, fnd_profile_options fpo
2931: where fpov.profile_option_id = fpo.profile_option_id
2932: and fpo.profile_option_name like 'XLA_MO_SECURITY_PROFILE_LEVEL'
2933: and fpov.level_id = 10001; -- Site level
2934: