APPS.PO_DOCUMENT_CHECKS_PVT dependencies on PO_AGENTS

Line 16097: 'EXISTS(SELECT NULL FROM PO_AGENTS WHERE agent_id= ' ||

16093: */
16094: ' AND POAH2.object_type_code = (DECODE(' || p_query_table || '.'||l_doctype_column||', ''BLANKET'', ''PA'', ''STANDARD'', ''PO'' , ''PLANNED'' , ''PO'' , ''CONTRACT'' , ''PA'', ''RELEASE'' , ''RELEASE'' ) ) ' ||
16095: /* End Bug 7229262/7239696 */
16096: ' AND POAH2.object_id = ' || p_query_table || '.' || l_id_column || ')) OR (' ||
16097: 'EXISTS(SELECT NULL FROM PO_AGENTS WHERE agent_id= ' ||
16098: p_employee_id || ' AND SYSDATE BETWEEN NVL(start_date_active, ' ||
16099: 'SYSDATE) AND NVL(end_date_active, SYSDATE+1))))' ||')'
16100: ||')';
16101: /*Bug6640107 : Here the document access level is the access level set in po_headers_v and the required access level is p_minimum_access_level.

Line 22218: po_agents pa,

22214: l_type_lookup_code, l_rate
22215: FROM po_warrant_lines pwl,
22216: po_user_warrants puw,
22217: po_doc_style_headers pdsh,
22218: po_agents pa,
22219: po_headers_all phm
22220: WHERE phm.po_header_id = p_header_id
22221: AND phm.style_id = pdsh.style_id
22222: AND p_contracting_officer = pa.agent_id

Line 22246: po_agents pa,

22242: l_type_lookup_code, l_rate
22243: FROM po_warrant_lines pwl,
22244: po_user_warrants puw,
22245: po_doc_style_headers pdsh,
22246: po_agents pa,
22247: po_headers_all phm
22248: WHERE phm.po_header_id = p_header_id
22249: AND phm.style_id = pdsh.style_id
22250: AND p_contracting_officer = pa.agent_id