DBA Data[Home] [Help]

APPS.POREQ dependencies on PO_POSITION_CONTROLS

Line 244: po_position_controls popc

240: SELECT Min(pocr.amount_limit)
241: INTO l_doc_approval_limit
242: FROM po_control_rules pocr,
243: po_control_groups pocg,
244: po_position_controls popc
245: WHERE popc.position_id = l_position_id
246: AND sysdate BETWEEN NVL(popc.start_date, sysdate - 1 )
247: AND NVL(popc.end_date,sysdate + 1 )
248: AND popc.control_function_id = l_control_function_id

Line 276: po_position_controls popc

272: SELECT Min(pocr.amount_limit)
273: INTO l_doc_approval_limit
274: FROM po_control_rules pocr,
275: po_control_groups pocg,
276: po_position_controls popc
277: WHERE popc.job_id = l_job_id
278: AND sysdate BETWEEN NVL(popc.start_date, sysdate - 1 )
279: AND NVL(popc.end_date,sysdate + 1 )
280: AND popc.control_function_id = l_control_function_id