APPS.PO_VAL_HEADERS2 dependencies on PO_AGENTS

Line 621: -- Agent Id must not be null and validate against PO_AGENTS.

617: RAISE;
618: END rate_info;
619:
620: -------------------------------------------------------------------------
621: -- Agent Id must not be null and validate against PO_AGENTS.
622: -------------------------------------------------------------------------
623: PROCEDURE agent_id(
624: p_id_tbl IN po_tbl_number,
625: p_agent_id_tbl IN po_tbl_number,

Line 642: -- validate agent_id against PO_AGENTS

638: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
639: END IF;
640:
641: x_result_type := po_validations.c_result_type_success;
642: -- validate agent_id against PO_AGENTS
643: FORALL i IN 1 .. p_id_tbl.COUNT
644: INSERT INTO po_validation_results_gt
645: (result_set_id,
646: result_type,

Line 674: FROM po_agents poa

670: FROM DUAL
671: WHERE p_agent_id_tbl(i) IS NULL
672: OR NOT EXISTS(
673: SELECT 1
674: FROM po_agents poa
675: WHERE p_agent_id_tbl(i) = poa.agent_id
676: AND SYSDATE BETWEEN NVL(poa.start_date_active, SYSDATE - 1)
677: AND NVL(poa.end_date_active, SYSDATE + 1));
678: