APPS.JTF_TERR_JSP_LOV_RECS_PUB dependencies on JTF_TERR_DENORM_RULES_ALL

Line 395: FROM jtf_terr_denorm_rules_all jtdr

391: where (UPPER(resource_name) like NVL(l_column1, '%') || '%'
392: -- ARPATEL09/08/2003 bug#2966686 fix
393: or l_column1 = '%')
394: AND EXISTS ( SELECT NULL
395: FROM jtf_terr_denorm_rules_all jtdr
396: WHERE jtdr.source_id = NVL(l_column2, source_id)
397: AND jtdr.terr_id = jtrv.terr_id
398: AND JTDR.RELATED_TERR_ID = JTRV.TERR_ID)
399: order by resource_name;

Line 506: FROM jtf_terr_denorm_rules_all jtdr

502: from JTF_TERR_RESOURCES_V jtr
503: where (jtr.end_date_active is null or jtr.end_date_active >= sysdate)
504: and jtr.group_id is not null
505: AND EXISTS ( SELECT NULL
506: FROM jtf_terr_denorm_rules_all jtdr
507: WHERE jtdr.source_id = -1001
508: AND jtdr.terr_id = jtr.terr_id
509: AND JTDR.RELATED_TERR_ID = JTR.TERR_ID )
510: order by group_name;