DBA Data[Home] [Help]

APPS.IGC_CBC_PO_YEAR_END_PKG dependencies on PO_HEADERS_ALL

Line 1519: po_headers_all poh

1515: Nvl(pod.encumbered_flag,'N'),
1516: pod.gl_encumbered_date,
1517: pod.gl_encumbered_period_name
1518: FROM po_distributions_all pod,
1519: po_headers_all poh
1520: WHERE (Nvl(pod.encumbered_amount+ pod.unencumbered_amount,0) > 0
1521: AND Nvl(pod.encumbered_amount+ pod.unencumbered_amount,0) <> Nvl(pod.unencumbered_amount,0)
1522: OR Nvl(pod.encumbered_amount+ pod.unencumbered_amount,0) <> Nvl(poh.blanket_total_amount,0))
1523: AND Nvl(poh.encumbrance_required_flag,'N') = 'Y'