DBA Data[Home] [Help]

APPS.JTF_UM_UTIL_PVT dependencies on FND_PROFILE

Line 1219: from fnd_profile_options

1215: --
1216: cursor profile_info is
1217: select profile_option_id,
1218: application_id
1219: from fnd_profile_options
1220: where profile_option_name = l_name_z
1221: and start_date_active <= sysdate
1222: and nvl(end_date_active, sysdate) >= sysdate;
1223:

Line 1230: from fnd_profile_option_values

1226: -- and user levels (10001/10002/10004)
1227: --
1228: cursor value_uas(pid number, aid number, lid number, lval number) is
1229: select profile_option_value
1230: from fnd_profile_option_values
1231: where profile_option_id = pid
1232: and application_id = aid
1233: and level_id = lid
1234: and level_value = lval;

Line 1242: from fnd_profile_option_values

1238: -- level (10003)
1239: --
1240: cursor value_resp(pid number, aid number, lval number, laid number) is
1241: select profile_option_value
1242: from fnd_profile_option_values
1243: where profile_option_id = pid
1244: and application_id = aid
1245: and level_id = 10003
1246: and level_value = lval

Line 1962: fnd_profile.get(

1958: l_nls_territory varchar2(30);
1959: l_territory_code varchar2(30);
1960:
1961: begin
1962: fnd_profile.get(
1963: name => 'ICX_TERRITORY',
1964: val => l_nls_territory
1965: );
1966: