APPS.JTF_TAE_ASSIGN_PUB dependencies on JTF_TERR_RSC_ALL

Line 424: FROM jtf_terr_rsc_all jtrs

420: AND NVL(jt1.end_date_active, lp_sysdate) >= lp_sysdate
421: AND jt1.start_date_active <= lp_sysdate
422: AND EXISTS (
423: SELECT jtrs.terr_rsc_id
424: FROM jtf_terr_rsc_all jtrs
425: WHERE NVL(jtrs.end_date_active, lp_sysdate) >= lp_sysdate
426: AND NVL(jtrs.start_date_active, lp_sysdate) <= lp_sysdate
427: AND jtrs.terr_id = jt1.terr_id )
428: AND NOT EXISTS (

Line 1074: ' , jtf_terr_rsc_all jtr ' ||

1070: ' , trans_detail_object_id ' ||
1071: ' , WIN_TERR_ID ' ||
1072: ' FROM ' || l_terr_WT_target ||
1073: ' ) WINNERS ' ||
1074: ' , jtf_terr_rsc_all jtr ' ||
1075: ' , jtf_terr_rsc_access_all jtra ' ||
1076: ' WHERE WINNERS.WIN_terr_id = jtr.terr_id ' ||
1077: ' AND ( ( jtr.end_date_active IS NULL OR jtr.end_date_active >= :BV1_SYSDATE ) AND ' ||
1078: ' ( jtr.start_date_active IS NULL OR jtr.start_date_active <= :BV2_SYSDATE ) ' ||

Line 1988: FROM jtf_terr_rsc_all jtrs

1984: AND NVL(jt1.end_date_active, lp_sysdate) >= lp_sysdate
1985: AND jt1.start_date_active <= lp_sysdate
1986: AND EXISTS (
1987: SELECT jtrs.terr_rsc_id
1988: FROM jtf_terr_rsc_all jtrs
1989: WHERE NVL(jtrs.end_date_active, lp_sysdate) >= lp_sysdate
1990: AND NVL(jtrs.start_date_active, lp_sysdate) <= lp_sysdate
1991: AND jtrs.terr_id = jt1.terr_id )
1992: AND NOT EXISTS (

Line 3003: ' , jtf_terr_rsc_all jtr ' ||

2999: ' , WIN_TERR_ID ' ||
3000: ' FROM ' || l_terr_WT_target ||
3001: ' WHERE WORKER_ID = :bv_worker_id ' ||
3002: ' ) WINNERS ' ||
3003: ' , jtf_terr_rsc_all jtr ' ||
3004: ' , jtf_terr_rsc_access_all jtra ' ||
3005: ' WHERE WINNERS.WIN_terr_id = jtr.terr_id ' ||
3006: ' AND ( ( jtr.end_date_active IS NULL OR jtr.end_date_active >= :BV1_SYSDATE ) AND ' ||
3007: ' ( jtr.start_date_active IS NULL OR jtr.start_date_active <= :BV2_SYSDATE ) ' ||