APPS.CN_WKSHT_GET_PUB dependencies on JTF_RS_RESOURCE_EXTNS

Line 103: jtf_rs_resource_extns_vl re2,

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,
106: least(pr.end_date,Nvl(m1.end_date_active,pr.end_date)) end_date
107: FROM jtf_rs_resource_extns re1,

Line 107: FROM jtf_rs_resource_extns re1,

103: jtf_rs_resource_extns_vl re2,
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

Line 265: FROM jtf_rs_resource_extns re1,

261: -- pay period
262: BEGIN
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