DBA Data[Home] [Help]

APPS.CSF_RESOURCE_PUB dependencies on JTF_RS_ALL_RESOURCES_VL

Line 1912: FROM jtf_rs_all_resources_vl r

1908: SELECT /*+ CARDINALITY(tr, 1) */
1909: r.resource_name
1910: , t.name terr_name
1911: , tr.resource_index
1912: FROM jtf_rs_all_resources_vl r
1913: , jtf_terr_all t
1914: , TABLE( CAST( x_res_tbl AS csf_resource_tbl ) ) tr
1915: WHERE r.resource_id = tr.resource_id
1916: AND r.resource_type = tr.resource_type

Line 2087: * In sync with the code done in JTF_RS_ALL_RESOURCES_VL

2083:
2084: /**
2085: * Returns the Resource Type Code corresponding to a Resource Category.
2086: *
2087: * In sync with the code done in JTF_RS_ALL_RESOURCES_VL
2088: *
2089: * @param p_category Resource Category
2090: * @returns Resource Type Code (VARCHAR2).
2091: */