APPS.OZF_FUNDS_PUB dependencies on JTF_TERR_QTYPE_USGS

Line 1482: FROM jtf_terr_qtype_usgs jtqu, jtf_terr jt, jtf_qual_type_usgs jqtu

1478: WHERE organization_id = p_segment_id;
1479:
1480: CURSOR c_segment_terr (p_segment_id IN NUMBER) IS
1481: SELECT 1
1482: FROM jtf_terr_qtype_usgs jtqu, jtf_terr jt, jtf_qual_type_usgs jqtu
1483: WHERE ( TRUNC(jt.start_date_active) <= TRUNC(SYSDATE)
1484: AND ( TRUNC(jt.end_date_active) >= TRUNC(SYSDATE) OR jt.end_date_active IS NULL ))
1485: AND jt.terr_id = jtqu.terr_id
1486: AND jtqu.qual_type_usg_id = jqtu.qual_type_usg_id