APPS.CN_WKSHT_GET_PUB dependencies on JTF_RS_GROUP_USAGES

Line 101: FROM jtf_rs_group_usages u2,

97: l_where5 VARCHAR2(5000) := ' s.assigned_to_user_name LIKE :B5 ';
98: l_where7 VARCHAR2(5000) := ' s.assigned_to_user_id IN (
99: SELECT
100: DISTINCT re2.user_id
101: FROM jtf_rs_group_usages u2,
102: jtf_rs_rep_managers m2,
103: jtf_rs_resource_extns_vl re2,
104: (SELECT DISTINCT m1.resource_id,
105: greatest(pr.start_date,m1.start_date_active) start_date,

Line 108: cn_period_statuses pr, jtf_rs_group_usages u1,

104: (SELECT DISTINCT m1.resource_id,
105: greatest(pr.start_date,m1.start_date_active) start_date,
106: least(pr.end_date,Nvl(m1.end_date_active,pr.end_date)) end_date
107: FROM jtf_rs_resource_extns re1,
108: cn_period_statuses pr, jtf_rs_group_usages u1,
109: jtf_rs_rep_managers m1
110: WHERE re1.user_id = :B7
111: AND pr.period_id
112: = ( select pay_period_id from cn_payruns where payrun_id = :B8)

Line 267: jtf_rs_group_usages u1,

263: SELECT 1 INTO l_tmp FROM dual WHERE exists
264: (SELECT 1
265: FROM jtf_rs_resource_extns re1,
266: cn_period_statuses pr,
267: jtf_rs_group_usages u1,
268: jtf_rs_rep_managers m1
269: WHERE re1.user_id = fnd_global.user_id
270: AND (pr.period_id, pr.org_id) = (
271: SELECT pay_period_id, org_id