APPS.OKL_CONTRACT_PVT dependencies on FND_PROFILE_OPTIONS_VL

Line 2394: from fnd_profile_options_vl

2390:
2391: --Bug# 3486065
2392: cursor profile_option_csr(p_profile_option_name in varchar2) is
2393: select user_profile_option_name
2394: from fnd_profile_options_vl
2395: where profile_option_name = p_profile_option_name;
2396:
2397: l_authoring_org_profile_name fnd_profile_options_vl.user_profile_option_name%type;
2398: l_inventory_org_profile_name fnd_profile_options_vl.user_profile_option_name%type;

Line 2397: l_authoring_org_profile_name fnd_profile_options_vl.user_profile_option_name%type;

2393: select user_profile_option_name
2394: from fnd_profile_options_vl
2395: where profile_option_name = p_profile_option_name;
2396:
2397: l_authoring_org_profile_name fnd_profile_options_vl.user_profile_option_name%type;
2398: l_inventory_org_profile_name fnd_profile_options_vl.user_profile_option_name%type;
2399: l_authoring_org_profile_value fnd_profile_option_values.profile_option_value%type;
2400: l_inventory_org_profile_value fnd_profile_option_values.profile_option_value%type;
2401:

Line 2398: l_inventory_org_profile_name fnd_profile_options_vl.user_profile_option_name%type;

2394: from fnd_profile_options_vl
2395: where profile_option_name = p_profile_option_name;
2396:
2397: l_authoring_org_profile_name fnd_profile_options_vl.user_profile_option_name%type;
2398: l_inventory_org_profile_name fnd_profile_options_vl.user_profile_option_name%type;
2399: l_authoring_org_profile_value fnd_profile_option_values.profile_option_value%type;
2400: l_inventory_org_profile_value fnd_profile_option_values.profile_option_value%type;
2401:
2402: l_deal_type OKL_K_HEADERS.deal_type%TYPE;