[Home] [Help]
187: -- Update the Accrued PO distribution, and mark accrued_flag as 'Y'
188: -------------------------------------------------------------------------
189: l_stmt_num := 70;
190: FORALL l_ctr IN g_accrued_dist_id_tbl.FIRST..g_accrued_dist_id_tbl.LAST
191: UPDATE po_distributions_all pod
192: SET pod.accrued_flag = 'Y'
193: WHERE pod.po_distribution_id = g_accrued_dist_id_tbl(l_ctr);
194:
195: -- Clear the PL/SQL table
615: FROM
616: po_headers_all poh,
617: po_lines_all pol,
618: po_line_locations_all poll,
619: po_distributions_all pod,
620: cst_organization_definitions cod,
621: mtl_system_items msi,
622: mtl_units_of_measure tuom,
623: mtl_units_of_measure puom
814: pod.budget_account_id enc_credit_ccid
815: FROM cst_per_end_accruals_temp cpea,
816: po_headers_all poh,
817: po_line_locations_all poll,
818: po_distributions_all pod,
819: fnd_currencies fnc1,
820: fnd_currencies fnc2,
821: gl_daily_conversion_types glct
822: WHERE pod.po_distribution_id = cpea.distribution_id