DBA Data[Home] [Help]

APPS.OE_BULK_VALIDATE dependencies on JTF_RS_RESOURCE_EXTNS

Line 1420: jtf_rs_resource_extns jre

1416: and sysdate between NVL(start_date_active,sysdate)
1417: and NVL(end_date_active,sysdate))
1418: AND NOT EXISTS (SELECT jrs.salesrep_id
1419: from jtf_rs_salesreps jrs,
1420: jtf_rs_resource_extns jre
1421: where jrs.salesrep_id = b.salesrep_id
1422: and jrs.resource_id = jre.resource_id
1423: and jre.category in ('EMPLOYEE','OTHER','PARTY','PARTNER','SUPPLIER_CONTACT')
1424: and jrs.org_id = l_org_id

Line 1472: jtf_rs_resource_extns jre

1468: and sysdate between NVL(start_date_active,sysdate)
1469: and NVL(end_date_active,sysdate))
1470: AND NOT EXISTS (SELECT jrs.salesrep_id
1471: from jtf_rs_salesreps jrs,
1472: jtf_rs_resource_extns jre
1473: where jrs.salesrep_id = b.salesrep_id
1474: and jrs.resource_id = jre.resource_id
1475: and jre.category in ('EMPLOYEE','OTHER','PARTY','PARTNER','SUPPLIER_CONTACT')
1476: and jrs.org_id = l_org_id