APPS.JTY_TERR_DENORM_RULES_PVT dependencies on JTF_QUAL_TYPES_ALL

Line 798: jtf_qual_types_all jqta

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

Line 859: jtf_qual_types_all jqta

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

Line 917: jtf_qual_types_all jqta

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

Line 975: jtf_qual_types_all jqta

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

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

991: 'PROGRAM_APPLICATION_ID', 'PROGRAM_ID', 'PROGRAM_UPDATE_DATE', 'DENORM_TERR_ATTR_VALUES_ID',
992: 'DENORM_TERR_DEA_VALUES_ID');
993:
994: TYPE l_qtype_terr_id_tbl_type IS TABLE OF jtf_terr_all.terr_id%TYPE;
995: TYPE l_qtype_trans_id_tbl_type IS TABLE OF jtf_qual_types_all.qual_type_id%TYPE;
996: TYPE l_qtype_source_id_tbl_type IS TABLE OF jtf_sources_all.source_id%TYPE;
997: TYPE l_qtype_num_qual_tbl_type IS TABLE OF jtf_terr_qtype_usgs_all.num_qual%TYPE;
998: TYPE l_qtype_qual_prd_tbl_type IS TABLE OF jtf_terr_qtype_usgs_all.qual_relation_product%TYPE;
999: