APPS.PO_COPYDOC_SUB dependencies on PO_AGENTS

Line 578: SELECT agent_id FROM po_agents

574: SELECT distinct 'Y'
575: INTO x_valid_flag
576: FROM po_buyers_val_v
577: WHERE employee_id = (
578: SELECT agent_id FROM po_agents
579: WHERE sysdate between nvl(start_date_active, sysdate-1)
580: and nvl(end_date_active, sysdate+1)
581: AND agent_id = x_buyer_id);
582: END IF;