APPS.BIX_UWQ_SUMMARY_PKG dependencies on JTF_RS_GROUP_MEMBERS

Line 659: from jtf_rs_group_members mem, jtf_rs_groups_denorm denorm,

655:
656: CURSOR c_all_groups
657: IS
658: select DISTINCT denorm.parent_group_id group_id
659: from jtf_rs_group_members mem, jtf_rs_groups_denorm denorm,
660: bix_dm_uwq_agent_sum summ
661: where mem.group_id = denorm.group_id
662: and summ.resource_id = mem.resource_id;
663:

Line 749: from jtf_rs_groups_denorm denorm, jtf_rs_group_members grp

745: v_current_month_login, v_current_month_duration
746: FROM bix_dm_uwq_agent_sum agent
747: WHERE agent.resource_id IN (
748: select grp.resource_id
749: from jtf_rs_groups_denorm denorm, jtf_rs_group_members grp
750: where denorm.parent_group_id = rec_groups.group_id
751: and denorm.group_id = grp.group_id
752: )
753: AND agent.day = v_insert_date;