APPS.JTF_RS_CONC_WF_PUB dependencies on JTF_RS_GROUPS_VL

Line 473: FROM jtf_rs_groups_vl grp, wf_local_roles wlr

469: -- Hints provided based on Perf. Team's recommendations (Jaikumar Bathija).
470: SELECT /*+ use_hash(grp.t) use_hash(grp.b) use_hash(wlr) parallel(grp) parallel(wlr) */
471: grp.group_id, grp.group_name, grp.email_address
472: ,grp.start_date_active, grp.end_date_active
473: FROM jtf_rs_groups_vl grp, wf_local_roles wlr
474: WHERE NVL(TRUNC(grp.end_date_active),l_sysdate) < l_sysdate
475: AND wlr.orig_system_id = grp.group_id
476: AND wlr.orig_system = l_grp_orig_system
477: AND wlr.name = l_grp_orig_system||':'||to_char(grp.group_id)

Line 492: FROM jtf_rs_groups_vl grp, wf_local_roles wlr

488: SELECT /*+ use_hash(grp.t) use_hash(grp.b) use_hash(wlr) parallel(grp) parallel(wlr) */
489: grp.group_id, grp.group_name, grp.email_address
490: ,grp.end_date_active, grp.start_date_active
491: ,wlr.start_date wlr_start_date, wlr.expiration_date wlr_exp_date
492: FROM jtf_rs_groups_vl grp, wf_local_roles wlr
493: WHERE NVL(TRUNC(grp.end_date_active),l_sysdate) >= l_sysdate
494: AND wlr.orig_system_id = grp.group_id
495: AND wlr.orig_system = l_grp_orig_system
496: AND wlr.name = l_grp_orig_system||':'||to_char(grp.group_id)

Line 535: FROM jtf_rs_groups_vl grp

531: -- Hints provided based on Perf. Team's recommendations (Jaikumar Bathija).
532: SELECT /*+ use_hash(grp.t) use_hash(grp.b) parallel(grp) */
533: grp.group_id, grp.group_name, grp.email_address
534: ,grp.end_date_active, grp.start_date_active
535: FROM jtf_rs_groups_vl grp
536: WHERE NVL(TRUNC(grp.end_date_active),l_sysdate) >= l_sysdate
537: AND NOT EXISTS (SELECT 1 FROM wf_local_roles wlr
538: WHERE wlr.orig_system = l_grp_orig_system
539: AND wlr.orig_system_id = grp.group_id