APPS.CN_PAYMENT_SECURITY_PVT dependencies on JTF_RS_RESOURCE_EXTNS_VL

Line 1218: jtf_rs_resource_extns_vl re2,

1214: WHERE EXISTS (
1215: SELECT 1
1216: FROM jtf_rs_group_usages u2,
1217: jtf_rs_rep_managers m2,
1218: jtf_rs_resource_extns_vl re2,
1219:
1220: -- start inline view
1221: -- get all rows for a login user in jtf_rs_rep_managers
1222: -- with period = p_period_id

Line 1718: FROM jtf_rs_group_usages u2,jtf_rs_rep_managers m2,jtf_rs_resource_extns_vl re2,

1714: as
1715: ret varchar2(1);
1716: begin
1717: SELECT DECODE( (SELECT 1 FROM dual WHERE EXISTS ( SELECT 1
1718: FROM jtf_rs_group_usages u2,jtf_rs_rep_managers m2,jtf_rs_resource_extns_vl re2,
1719: (SELECT DISTINCT m1.resource_id, GREATEST(pr.start_date,m1.start_date_active) start_date,LEAST(pr.end_date,Nvl(m1.end_date_active,pr.end_date)) end_date
1720: FROM cn_period_statuses pr,jtf_rs_group_usages u1, jtf_rs_rep_managers m1
1721: WHERE pr.period_id = (SELECT p1.pay_period_id FROM cn_payruns p1 WHERE p1.payrun_id = p_payrun_id)
1722: AND pr.org_id =(SELECT org_id FROM cn_payruns where payrun_id=p_payrun_id)