DBA Data[Home] [Help]

APPS.CSR_SCHEDULER_PVT dependencies on JTF_TERR_ALL

Line 1060: FROM jtf_terr_rsc_all trs, jtf_terr_all tra

1056: (tra.absolute_rank,
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;