DBA Data[Home] [Help]

APPS.JTF_TTY_ALIGN_ACTIVATE_PKG dependencies on JTF_RS_GROUP_USAGES

Line 190: FROM jtf_rs_group_usages usg

186: AND grpmemo.delete_flag = 'N'
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'

Line 257: FROM jtf_rs_group_usages usg

253: , jtf_rs_role_relations rlt
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'