DBA Data[Home] [Help]

APPS.JTY_TERR_DENORM_RULES_PVT dependencies on JTF_TERR_RSC_ACCESS_ALL

Line 881: jtf_terr_rsc_access_all jtra,

877: AND jtqa.qual_usg_id <> -1102 -- eliminate CNRG
878: AND EXISTS
879: (SELECT 1
880: FROM jtf_terr_rsc_all jtr,
881: jtf_terr_rsc_access_all jtra,
882: jtf_qual_types_all jqta
883: WHERE jtr.terr_id = jta.terr_id
884: AND jtr.end_date_active >= sysdate
885: AND jtr.start_date_active <= sysdate

Line 942: jtf_terr_rsc_access_all jtra,

938: AND cnrg.cnr_group_id = cnrgv.cnr_group_id
939: AND EXISTS
940: (SELECT 1
941: FROM jtf_terr_rsc_all jtr,
942: jtf_terr_rsc_access_all jtra,
943: jtf_qual_types_all jqta
944: WHERE jtr.terr_id = jta.terr_id
945: AND jtr.end_date_active >= sysdate
946: AND jtr.start_date_active <= sysdate

Line 1000: jtf_terr_rsc_access_all jtra,

996: AND jtqa.qual_usg_id <> -1102 -- eliminate CNRG
997: AND EXISTS
998: (SELECT 1
999: FROM jtf_terr_rsc_all jtr,
1000: jtf_terr_rsc_access_all jtra,
1001: jtf_qual_types_all jqta
1002: WHERE jtr.terr_id = jta.terr_id
1003: AND jtr.resource_type <> 'RS_ROLE'
1004: AND jtr.terr_rsc_id = jtra.terr_rsc_id

Line 1058: jtf_terr_rsc_access_all jtra,

1054: AND cnrg.cnr_group_id = cnrgv.cnr_group_id
1055: AND EXISTS
1056: (SELECT 1
1057: FROM jtf_terr_rsc_all jtr,
1058: jtf_terr_rsc_access_all jtra,
1059: jtf_qual_types_all jqta
1060: WHERE jtr.terr_id = jta.terr_id
1061: AND jtr.resource_type <> 'RS_ROLE'
1062: AND jtr.terr_rsc_id = jtra.terr_rsc_id