APPS.PO_COPYDOC_SUB dependencies on PO_AGENTS

Line 535: SELECT agent_id FROM po_agents

531: SELECT distinct 'Y'
532: INTO x_valid_flag
533: FROM po_buyers_val_v
534: WHERE employee_id = (
535: SELECT agent_id FROM po_agents
536: WHERE sysdate between nvl(start_date_active, sysdate-1)
537: and nvl(end_date_active, sysdate+1)
538: AND agent_id = x_buyer_id);
539: END IF;