APPS.OZF_FUNDS_PUB dependencies on JTF_QUAL_TYPE_USGS

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

1448: WHERE organization_id = p_segment_id;
1449:
1450: CURSOR c_segment_terr (p_segment_id IN NUMBER) IS
1451: SELECT 1
1452: FROM jtf_terr_qtype_usgs jtqu, jtf_terr jt, jtf_qual_type_usgs jqtu
1453: WHERE ( TRUNC(jt.start_date_active) <= TRUNC(SYSDATE)
1454: AND ( TRUNC(jt.end_date_active) >= TRUNC(SYSDATE) OR jt.end_date_active IS NULL ))
1455: AND jt.terr_id = jtqu.terr_id
1456: AND jtqu.qual_type_usg_id = jqtu.qual_type_usg_id