eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_TAP_ACCESS_TERRS_PVT dependencies on JTF_TERR_ALL

Line 924: -- check, the supplied territory in the JTF_TERR_ALL table is ACTIVE and EXISTS.

920: SELECT 'Y'
921: FROM pv_partner_accesses
922: WHERE partner_access_id = cv_partner_access_id;
923:
924: -- check, the supplied territory in the JTF_TERR_ALL table is ACTIVE and EXISTS.
925: CURSOR l_chk_terr_active_csr(cv_terr_id IN NUMBER) IS
926: SELECT 'Y'
927: FROM jtf_terr_all
928: WHERE terr_id = cv_terr_id

Line 927: FROM jtf_terr_all

923:
924: -- check, the supplied territory in the JTF_TERR_ALL table is ACTIVE and EXISTS.
925: CURSOR l_chk_terr_active_csr(cv_terr_id IN NUMBER) IS
926: SELECT 'Y'
927: FROM jtf_terr_all
928: WHERE terr_id = cv_terr_id
929: AND nvl(end_date_active , sysdate) >= sysdate;
930:
931: -- Local variale declaration.