DBA Data[Home] [Help]

APPS.JTF_TTY_ALIGN_ACTIVATE_PKG dependencies on JTF_RS_REP_MANAGERS

Line 192: , jtf_rs_rep_managers sgh

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
196: -- AND dv.immediate_parent_flag = 'Y'

Line 259: , jtf_rs_rep_managers sgh

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
263: AND ( dv.immediate_parent_flag = 'Y' OR dv.group_id = dv.parent_group_id )