DBA Data[Home] [Help]

APPS.OKC_REPORT_PVT dependencies on FND_PROFILE_OPTIONS_VL

Line 158: from fnd_profile_options_vl

154: l_message varchar2(2000);
155: l_token varchar2(240);
156: cursor profile_option_csr(p_profile_option varchar2) is
157: select USER_PROFILE_OPTION_NAME
158: from fnd_profile_options_vl
159: where application_id=510
160: and PROFILE_OPTION_NAME = p_profile_option;
161: begin
162: open profile_option_csr(p_prof_name);

Line 1491: from fnd_profile_options_vl

1487: and not(sysdate between Q.START_DATE and NVL(Q.END_DATE,sysdate))
1488: ;
1489: cursor profile_options_csr is
1490: select '"'||USER_PROFILE_OPTION_NAME||'"'
1491: from fnd_profile_options_vl
1492: where application_id=510
1493: and PROFILE_OPTION_NAME = 'OKC_WEB_REPORT'
1494: ;
1495: