APPS.BIX_UWQ_TEMP_PKG dependencies on JTF_RS_GROUPS_DENORM

Line 132: from jtf_rs_groups_denorm denorm

128:
129: CURSOR c_child_groups(p_group_id INTEGER)
130: IS
131: select denorm.group_id GID
132: from jtf_rs_groups_denorm denorm
133: where denorm.parent_group_id = p_group_id
134: and denorm.immediate_parent_flag = 'Y';
135:
136: --

Line 337: from jtf_rs_groups_denorm denorm

333: v_session_id
334: FROM bix_dm_uwq_group_sum summ, jtf_rs_groups_vl vl
335: WHERE summ.group_id IN
336: (select denorm.group_id GID
337: from jtf_rs_groups_denorm denorm
338: where denorm.parent_group_id = substr(v_context,13)
339: and denorm.immediate_parent_flag = 'Y'
340: )
341: AND summ.group_id = vl.group_id

Line 401: from jtf_rs_groups_denorm denorm

397: v_session_id
398: FROM bix_dm_uwq_group_sum summ, jtf_rs_groups_vl vl
399: WHERE summ.group_id IN
400: (select denorm.group_id GID
401: from jtf_rs_groups_denorm denorm
402: where denorm.parent_group_id = v_default_group_id
403: and denorm.immediate_parent_flag = 'Y'
404: )
405: AND summ.group_id = vl.group_id

Line 542: from jtf_rs_groups_denorm denorm

538: v_session_id
539: FROM bix_dm_uwq_group_sum summ, jtf_rs_groups_vl vl
540: WHERE summ.group_id IN
541: (select denorm.group_id GID
542: from jtf_rs_groups_denorm denorm
543: where denorm.parent_group_id = substr(v_context,13)
544: and denorm.immediate_parent_flag = 'Y'
545: )
546: AND summ.group_id = vl.group_id

Line 633: from jtf_rs_groups_denorm denorm

629: v_session_id
630: FROM bix_dm_uwq_group_sum summ, jtf_rs_groups_vl vl
631: WHERE summ.group_id IN
632: (select denorm.group_id GID
633: from jtf_rs_groups_denorm denorm
634: where denorm.parent_group_id = v_default_group_id
635: and denorm.immediate_parent_flag = 'Y'
636: )
637: AND summ.group_id = vl.group_id