DBA Data[Home] [Help]

APPS.POREQ dependencies on PO_CONTROL_RULES

Line 242: FROM po_control_rules pocr,

238: --
239: --
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 )

Line 274: FROM po_control_rules pocr,

270: end if;
271: --
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 )