DBA Data[Home] [Help]

APPS.OE_BULK_VALIDATE dependencies on RA_SALESREPS_ALL

Line 1414: from ra_salesreps_all a

1410: FROM OE_HEADERS_IFACE_ALL b
1411: WHERE batch_id = p_batch_id
1412: AND b.salesrep_id IS NOT NULL
1413: AND NOT EXISTS (SELECT a.salesrep_id
1414: from ra_salesreps_all a
1415: where salesrep_id =b.salesrep_id
1416: and sysdate between NVL(start_date_active,sysdate)
1417: and NVL(end_date_active,sysdate))
1418: AND NOT EXISTS (SELECT jrs.salesrep_id

Line 1466: from ra_salesreps_all a

1462: FROM OE_HEADERS_IFACE_ALL
1463: WHERE batch_id = p_batch_id)
1464: AND b.salesrep_id IS NOT NULL
1465: AND NOT EXISTS (SELECT a.salesrep_id
1466: from ra_salesreps_all a
1467: where salesrep_id =b.salesrep_id
1468: and sysdate between NVL(start_date_active,sysdate)
1469: and NVL(end_date_active,sysdate))
1470: AND NOT EXISTS (SELECT jrs.salesrep_id