APPS.OKC_REPORT_PVT dependencies on OKC_REPORT_PRM_V

Line 823: okc_report_prm_v P

819: cursor c2 (p_xid number) is
820: select '!'
821: from
822: okc_report_xst X,
823: okc_report_prm_v P
824: where X.ID = p_xid
825: and P.sql_id = X.sql_id
826: and P.code not in ('xid', 'kid', 'vid', 'content_type');
827: l_value varchar2(200);

Line 1892: from OKC_REPORT_PRM_V

1888: type,
1889: required_yn,
1890: lov_query,
1891: OKC_PARAMETERS_PUB.get(code) value
1892: from OKC_REPORT_PRM_V
1893: where sql_id = p
1894: order by sequence_num;
1895: r c1%ROWTYPE;
1896:

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