[Home] [Help]
689: Add_To_PackageTable (' , mgr.source_phone resource_mgr_phone ' );
690: Add_To_PackageTable (' , mgr.source_email resource_mgr_email ' );
691: Add_To_PackageTable (' , lp_terr_id terr_id ' );
692: Add_To_PackageTable (' FROM ' );
693: Add_To_PackageTable (' jtf_terr_rsc_all jtr ' );
694: Add_To_PackageTable (' , jtf_terr_rsc_access_all jtra ' );
695: Add_To_PackageTable (' , jtf_rs_resource_extns_vl rsc ' );
696: Add_To_PackageTable (' , jtf_rs_resource_extns_vl mgr ' );
697: Add_To_PackageTable (' WHERE mgr.source_id (+) = rsc.source_mgr_id ' );
1048:
1049: Add_To_PackageTable (' '' ) o '' || ' );
1050: Add_To_PackageTable (' '' WHERE o.TERR_RANK <= (SELECT NVL(t.num_winners, 1) FROM jtf_terr_all t WHERE t.terr_id = o.top_level_terr_id) '' || ' );
1051: Add_To_PackageTable (' '' ) WT '' || ' );
1052: Add_To_PackageTable (' '' , jtf_terr_rsc_all jtra '' || ' );
1053: Add_To_PackageTable (' '' , jtf_terr_rsc_access_all jtraa '' || ' );
1054: Add_To_PackageTable (' '' WHERE '' || ' );
1055:
1056: IF (p_qualifier_type_id = -1002) THEN
1444: AND NVL(jt1.end_date_active, lp_sysdate) >= lp_sysdate
1445: AND jt1.start_date_active <= lp_sysdate
1446: AND EXISTS (
1447: SELECT jtrs.terr_rsc_id
1448: FROM jtf_terr_rsc_all jtrs
1449: WHERE NVL(jtrs.end_date_active, lp_sysdate) >= lp_sysdate
1450: AND NVL(jtrs.start_date_active, lp_sysdate) <= lp_sysdate
1451: AND jtrs.terr_id = jt1.terr_id )
1452: AND NOT EXISTS (
1483: AND NVL(jt1.end_date_active, lp_sysdate) >= lp_sysdate
1484: AND jt1.start_date_active <= lp_sysdate
1485: AND EXISTS (
1486: SELECT jtrs.terr_rsc_id
1487: FROM jtf_terr_rsc_all jtrs
1488: WHERE NVL(jtrs.end_date_active, lp_sysdate) >= lp_sysdate
1489: AND NVL(jtrs.start_date_active, lp_sysdate) <= lp_sysdate
1490: AND jtrs.terr_id = jt1.terr_id )
1491: AND NOT EXISTS (