2457:
2458: --Bug# 3486065
2459: cursor profile_option_csr(p_profile_option_name in varchar2) is
2460: select user_profile_option_name
2461: from fnd_profile_options_vl
2462: where profile_option_name = p_profile_option_name;
2463:
2464: l_authoring_org_profile_name fnd_profile_options_vl.user_profile_option_name%type;
2465: l_inventory_org_profile_name fnd_profile_options_vl.user_profile_option_name%type;
2460: select user_profile_option_name
2461: from fnd_profile_options_vl
2462: where profile_option_name = p_profile_option_name;
2463:
2464: l_authoring_org_profile_name fnd_profile_options_vl.user_profile_option_name%type;
2465: l_inventory_org_profile_name fnd_profile_options_vl.user_profile_option_name%type;
2466: l_authoring_org_profile_value fnd_profile_option_values.profile_option_value%type;
2467: l_inventory_org_profile_value fnd_profile_option_values.profile_option_value%type;
2468:
2461: from fnd_profile_options_vl
2462: where profile_option_name = p_profile_option_name;
2463:
2464: l_authoring_org_profile_name fnd_profile_options_vl.user_profile_option_name%type;
2465: l_inventory_org_profile_name fnd_profile_options_vl.user_profile_option_name%type;
2466: l_authoring_org_profile_value fnd_profile_option_values.profile_option_value%type;
2467: l_inventory_org_profile_value fnd_profile_option_values.profile_option_value%type;
2468:
2469: l_deal_type OKL_K_HEADERS.deal_type%TYPE;