APPS.CSR_SCHEDULER_PVT dependencies on CSF_UTIL_PVT

Line 920: l_where := csf_util_pvt.get_query_where(p_query_id);

916: END IF;
917:
918: -- Get the WHERE CLAUSE for the Given Query ID.
919:
920: l_where := csf_util_pvt.get_query_where(p_query_id);
921:
922: IF l_where IS NULL THEN
923: RAISE no_data_found;
924: END IF;

Line 990: , TABLE( CAST ( csf_util_pvt.get_selected_terr_table AS jtf_number_table ) ) t

986:
987: CURSOR c_resources IS
988: SELECT /*+ cardinality(t, 1) */ DISTINCT tr.resource_id, tr.resource_type
989: FROM jtf_terr_rsc_all tr
990: , TABLE( CAST ( csf_util_pvt.get_selected_terr_table AS jtf_number_table ) ) t
991: WHERE tr.terr_id = t.column_value
992: AND (p_terr_id IS NULL OR tr.terr_id = p_terr_id);
993:
994: l_res_id_tbl jtf_number_table;