DBA Data[Home] [Help]

APPS.JTY_TERR_ENGINE_GEN2_PVT dependencies on JTF_TERR_RSC_ALL

Line 1463: FROM jtf_terr_rsc_all jtr,

1459: AND jt1.end_date_active >= l_start_date
1460: AND jt1.start_date_active <= l_end_date
1461: AND EXISTS (
1462: SELECT 1
1463: FROM jtf_terr_rsc_all jtr,
1464: jtf_terr_rsc_access_all jtra,
1465: jtf_qual_types_all jqta
1466: WHERE jtr.terr_id = jt1.terr_id
1467: AND jtr.end_date_active >= l_start_date

Line 1495: FROM jtf_terr_rsc_all jtr,

1491: AND jt1.end_date_active >= l_start_date
1492: AND jt1.start_date_active <= l_end_date
1493: AND EXISTS (
1494: SELECT 1
1495: FROM jtf_terr_rsc_all jtr,
1496: jtf_terr_rsc_access_all jtra,
1497: jtf_qual_types_all jqta
1498: WHERE jtr.terr_id = jt1.terr_id
1499: AND jtr.end_date_active >= l_start_date