APPS.OKC_REPORT_PVT dependencies on OKC_REPORT_XST_V

Line 609: from OKC_REPORT_XST_V T, OKC_REPORT_XSL_V L

605: l_cached varchar2(1);
606: l_xst_date DATE;
607: cursor xst_csr(p_xst number) is
608: select T.CACHE_YN
609: from OKC_REPORT_XST_V T, OKC_REPORT_XSL_V L
610: where T.id = p_xst
611: and T.XSL_ID = L.ID
612: and sysdate between L.start_date and nvl(L.end_date,sysdate);
613: l_dummy varchar2(1);

Line 2056: from okc_report_prm_v PRM, okc_report_xst_v XST

2052: x_description out nocopy varchar2,
2053: x_sql out nocopy varchar2) is
2054: cursor c1 is
2055: select replace(prompt,'<',fnd_global.local_chr(38)||'lt;'), lov_query
2056: from okc_report_prm_v PRM, okc_report_xst_v XST
2057: where PRM.sql_id = XST.sql_id
2058: and XST.id = fnd_profile.value('OKC_WEB_REPORT')
2059: and PRM.code = OKC_PARAMETERS_PUB.get('__param_code');
2060: cursor c2 is