APPS.PO_VAL_HEADERS2 dependencies on PO_AGENTS

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

610: RAISE;
611: END rate_info;
612:
613: -------------------------------------------------------------------------
614: -- Agent Id must not be null and validate against PO_AGENTS.
615: -------------------------------------------------------------------------
616: PROCEDURE agent_id(
617: p_id_tbl IN po_tbl_number,
618: p_agent_id_tbl IN po_tbl_number,

Line 635: -- validate agent_id against PO_AGENTS

631: po_log.proc_begin(d_mod, 'x_result_set_id', x_result_set_id);
632: END IF;
633:
634: x_result_type := po_validations.c_result_type_success;
635: -- validate agent_id against PO_AGENTS
636: FORALL i IN 1 .. p_id_tbl.COUNT
637: INSERT INTO po_validation_results_gt
638: (result_set_id,
639: result_type,

Line 667: FROM po_agents poa

663: FROM DUAL
664: WHERE p_agent_id_tbl(i) IS NULL
665: OR NOT EXISTS(
666: SELECT 1
667: FROM po_agents poa
668: WHERE p_agent_id_tbl(i) = poa.agent_id
669: AND SYSDATE BETWEEN NVL(poa.start_date_active, SYSDATE - 1)
670: AND NVL(poa.end_date_active, SYSDATE + 1));
671: