APPS.JTY_TERR_DENORM_RULES_PVT dependencies on JTF_QUAL_TYPES_ALL

Line 882: jtf_qual_types_all jqta

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
886: AND jtr.resource_type <> 'RS_ROLE'

Line 943: jtf_qual_types_all jqta

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
947: AND jtr.resource_type <> 'RS_ROLE'

Line 1001: jtf_qual_types_all jqta

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
1005: AND jtra.access_type = jqta.name

Line 1059: jtf_qual_types_all jqta

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
1063: AND jtra.access_type = jqta.name

Line 1092: TYPE l_qtype_trans_id_tbl_type IS TABLE OF jtf_qual_types_all.qual_type_id%TYPE;

1088: AND SYSDATE BETWEEN JTA.START_DATE_ACTIVE AND JTA.END_DATE_ACTIVE;
1089:
1090:
1091: TYPE l_qtype_terr_id_tbl_type IS TABLE OF jtf_terr_all.terr_id%TYPE;
1092: TYPE l_qtype_trans_id_tbl_type IS TABLE OF jtf_qual_types_all.qual_type_id%TYPE;
1093: TYPE l_qtype_source_id_tbl_type IS TABLE OF jtf_sources_all.source_id%TYPE;
1094: TYPE l_qtype_num_qual_tbl_type IS TABLE OF jtf_terr_qtype_usgs_all.num_qual%TYPE;
1095: TYPE l_qtype_qual_prd_tbl_type IS TABLE OF jtf_terr_qtype_usgs_all.qual_relation_product%TYPE;
1096: