APPS.CN_API dependencies on JTF_RS_RESOURCE_EXTNS

Line 3345: jtf_rs_resource_extns_vl re2,

3341: is
3342: SELECT DISTINCT re2.user_id
3343: FROM jtf_rs_group_usages u2,
3344: jtf_rs_rep_managers m2,
3345: jtf_rs_resource_extns_vl re2,
3346: (SELECT DISTINCT m1.resource_id,
3347: greatest(pr.start_date, m1.start_date_active) start_date,
3348: least(pr.end_date, nvl(m1.end_date_active, pr.end_date)) end_date
3349: FROM jtf_rs_resource_extns re1,

Line 3349: FROM jtf_rs_resource_extns re1,

3345: jtf_rs_resource_extns_vl re2,
3346: (SELECT DISTINCT m1.resource_id,
3347: greatest(pr.start_date, m1.start_date_active) start_date,
3348: least(pr.end_date, nvl(m1.end_date_active, pr.end_date)) end_date
3349: FROM jtf_rs_resource_extns re1,
3350: cn_period_statuses pr,
3351: jtf_rs_group_usages u1,
3352: jtf_rs_rep_managers m1
3353: WHERE re1.user_id = l_user_id --129941

Line 3414: jtf_rs_resource_extns_vl re2,

3410: is
3411: SELECT DISTINCT re2.user_id
3412: FROM jtf_rs_group_usages u2,
3413: jtf_rs_rep_managers m2,
3414: jtf_rs_resource_extns_vl re2,
3415: (SELECT DISTINCT m1.resource_id,
3416: greatest(pr.start_date, m1.start_date_active) start_date,
3417: least(pr.end_date, nvl(m1.end_date_active, pr.end_date)) end_date
3418: FROM jtf_rs_resource_extns re1,

Line 3418: FROM jtf_rs_resource_extns re1,

3414: jtf_rs_resource_extns_vl re2,
3415: (SELECT DISTINCT m1.resource_id,
3416: greatest(pr.start_date, m1.start_date_active) start_date,
3417: least(pr.end_date, nvl(m1.end_date_active, pr.end_date)) end_date
3418: FROM jtf_rs_resource_extns re1,
3419: cn_period_statuses pr,
3420: jtf_rs_group_usages u1,
3421: jtf_rs_rep_managers m1
3422: WHERE re1.user_id = l_user_id --129941