DBA Data[Home] [Help]

APPS.JTY_TERR_DENORM_RULES_PVT dependencies on JTF_TERR_RSC_ACCESS_ALL

Line 797: jtf_terr_rsc_access_all jtra,

793: AND jtqa.qual_usg_id <> -1102 -- eliminate CNRG
794: AND EXISTS
795: (SELECT 1
796: FROM jtf_terr_rsc_all jtr,
797: jtf_terr_rsc_access_all jtra,
798: jtf_qual_types_all jqta
799: WHERE jtr.terr_id = jta.terr_id
800: AND jtr.end_date_active >= sysdate
801: AND jtr.start_date_active <= sysdate

Line 858: jtf_terr_rsc_access_all jtra,

854: AND cnrg.cnr_group_id = cnrgv.cnr_group_id
855: AND EXISTS
856: (SELECT 1
857: FROM jtf_terr_rsc_all jtr,
858: jtf_terr_rsc_access_all jtra,
859: jtf_qual_types_all jqta
860: WHERE jtr.terr_id = jta.terr_id
861: AND jtr.end_date_active >= sysdate
862: AND jtr.start_date_active <= sysdate

Line 916: jtf_terr_rsc_access_all jtra,

912: AND jtqa.qual_usg_id <> -1102 -- eliminate CNRG
913: AND EXISTS
914: (SELECT 1
915: FROM jtf_terr_rsc_all jtr,
916: jtf_terr_rsc_access_all jtra,
917: jtf_qual_types_all jqta
918: WHERE jtr.terr_id = jta.terr_id
919: AND jtr.resource_type <> 'RS_ROLE'
920: AND jtr.terr_rsc_id = jtra.terr_rsc_id

Line 974: jtf_terr_rsc_access_all jtra,

970: AND cnrg.cnr_group_id = cnrgv.cnr_group_id
971: AND EXISTS
972: (SELECT 1
973: FROM jtf_terr_rsc_all jtr,
974: jtf_terr_rsc_access_all jtra,
975: jtf_qual_types_all jqta
976: WHERE jtr.terr_id = jta.terr_id
977: AND jtr.resource_type <> 'RS_ROLE'
978: AND jtr.terr_rsc_id = jtra.terr_rsc_id