DBA Data[Home] [Help]

APPS.CN_API dependencies on JTF_RS_RESOURCE_EXTNS_VL

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 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,