DBA Data[Home] [Help]

APPS.CSR_SCHEDULER_PVT dependencies on JTF_TERR_RSC_ALL

Line 989: FROM jtf_terr_rsc_all tr

985: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_OPTIMIZE_TRIPS_REQUEST';
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: