DBA Data[Home] [Help]

APPS.JTF_TTY_ALIGN_ACTIVATE_PKG dependencies on JTF_RS_GROUPS_DENORM

Line 191: , jtf_rs_groups_denorm dv

187: AND grpmemo.resource_id = dir.resource_id
188: AND SYSDATE BETWEEN dir.start_date_active AND NVL(dir.end_date_active, SYSDATE+1)
189: AND grpmemo.group_id IN ( SELECT dv.group_id
190: FROM jtf_rs_group_usages usg
191: , jtf_rs_groups_denorm dv
192: , jtf_rs_rep_managers sgh
193: , jtf_rs_resource_extns mrsc
194: WHERE usg.usage = 'SALES'
195: AND usg.group_id = dv.group_id

Line 258: , jtf_rs_groups_denorm dv

254: , jtf_rs_group_members grpmemo
255: , jtf_rs_resource_extns dir
256: , ( SELECT distinct dv.group_id, dv.immediate_parent_flag child_group_flag
257: FROM jtf_rs_group_usages usg
258: , jtf_rs_groups_denorm dv
259: , jtf_rs_rep_managers sgh
260: , jtf_rs_resource_extns mrsc
261: WHERE usg.usage = 'SALES'
262: AND usg.group_id = dv.group_id