APPS.JTY_ASSIGN_BULK_PUB dependencies on JTF_QUAL_TYPES_ALL

Line 1291: jtf_qual_types_all jqta

1287: AND EXISTS (
1288: SELECT 1
1289: FROM jtf_terr_rsc_all jtr,
1290: jtf_terr_rsc_access_all jtra,
1291: jtf_qual_types_all jqta
1292: WHERE jtr.terr_id = jt1.terr_id
1293: AND jtr.end_date_active >= l_sysdate
1294: AND jtr.start_date_active <= l_sysdate
1295: AND jtr.resource_type <> 'RS_ROLE'

Line 2765: ' , jtf_qual_types_all jqta ' ||

2761: ' WHERE o.TERR_RANK <= (SELECT NVL(t.num_winners, 1) FROM jtf_terr_all t WHERE t.terr_id = o.top_level_terr_id) ' ||
2762: ' ) WT ' ||
2763: ' , jtf_terr_rsc_all jtr ' ||
2764: ' , jtf_terr_rsc_access_all jtra ' ||
2765: ' , jtf_qual_types_all jqta ' ||
2766: ' , (SELECT ' ||
2767: ' max(role_id) role_id ' ||
2768: ' ,role_code role_code ' ||
2769: ' FROM jtf_rs_roles_b ' ||

Line 3549: ' , jtf_qual_types_all jqta ' ||

3545: ' AND a.link = b.trans_object_id ' ||
3546: ' ) WINNERS ' ||
3547: ' , jtf_terr_rsc_all jtr ' ||
3548: ' , jtf_terr_rsc_access_all jtra ' ||
3549: ' , jtf_qual_types_all jqta ' ||
3550: ' , (SELECT ' ||
3551: ' max(role_id) role_id ' ||
3552: ' ,role_code role_code ' ||
3553: ' FROM jtf_rs_roles_b ' ||