APPS.CSR_SCHEDULER_PVT dependencies on CSF_UTIL_PVT

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

981: END IF;
982:
983: -- Get the WHERE CLAUSE for the Given Query ID.
984:
985: l_where := csf_util_pvt.get_query_where(p_query_id);
986:
987: IF l_where IS NULL THEN
988: RAISE no_data_found;
989: END IF;

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

1057: 0
1058: ) DESC NULLS LAST)
1059: AS comp_rank
1060: FROM jtf_terr_rsc_all trs, jtf_terr_all tra
1061: , TABLE( CAST ( csf_util_pvt.get_selected_terr_table AS jtf_number_table ) ) t
1062: WHERE trs.terr_id = t.column_value
1063: AND (p_terr_id IS NULL OR trs.terr_id = p_terr_id))
1064: WHERE comp_rank = 1;
1065: