APPS.JTF_RS_CONC_WF_PUB dependencies on JTF_RS_GROUPS_VL

Line 417: FROM jtf_rs_groups_vl grp, wf_local_roles wlr

413: -- Hints provided based on Perf. Team's recommendations (Jaikumar Bathija).
414: SELECT /*+ use_hash(grp.t) use_hash(grp.b) use_hash(wlr) parallel(grp) parallel(wlr) */
415: grp.group_id, grp.group_name, grp.email_address
416: ,grp.start_date_active, grp.end_date_active
417: FROM jtf_rs_groups_vl grp, wf_local_roles wlr
418: WHERE NVL(TRUNC(grp.end_date_active),l_sysdate) < l_sysdate
419: AND wlr.orig_system_id = grp.group_id
420: AND wlr.orig_system = l_grp_orig_system
421: AND wlr.name = l_grp_orig_system||':'||to_char(grp.group_id)

Line 436: FROM jtf_rs_groups_vl grp, wf_local_roles wlr

432: SELECT /*+ use_hash(grp.t) use_hash(grp.b) use_hash(wlr) parallel(grp) parallel(wlr) */
433: grp.group_id, grp.group_name, grp.email_address
434: ,grp.end_date_active, grp.start_date_active
435: ,wlr.start_date wlr_start_date, wlr.expiration_date wlr_exp_date
436: FROM jtf_rs_groups_vl grp, wf_local_roles wlr
437: WHERE NVL(TRUNC(grp.end_date_active),l_sysdate) >= l_sysdate
438: AND wlr.orig_system_id = grp.group_id
439: AND wlr.orig_system = l_grp_orig_system
440: AND wlr.name = l_grp_orig_system||':'||to_char(grp.group_id)

Line 479: FROM jtf_rs_groups_vl grp

475: -- Hints provided based on Perf. Team's recommendations (Jaikumar Bathija).
476: SELECT /*+ use_hash(grp.t) use_hash(grp.b) parallel(grp) */
477: grp.group_id, grp.group_name, grp.email_address
478: ,grp.end_date_active, grp.start_date_active
479: FROM jtf_rs_groups_vl grp
480: WHERE NVL(TRUNC(grp.end_date_active),l_sysdate) >= l_sysdate
481: AND NOT EXISTS (SELECT 1 FROM wf_local_roles wlr
482: WHERE wlr.orig_system = l_grp_orig_system
483: AND wlr.orig_system_id = grp.group_id