APPS.CN_WKSHT_GET_PUB dependencies on CN_PERIOD_STATUSES

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 266: cn_period_statuses pr,

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
270: AND (pr.period_id, pr.org_id) = (