APPS.PO_PARTIAL_FUNDING_PKG dependencies on GL_SETS_OF_BOOKS

Line 221: -- to table of varchar as the data is inserted from GL_SETS_OF_BOOKS, currency

217: l_rate_tbl PO_TBL_NUMBER;
218: l_qty_funded_tbl PO_TBL_NUMBER;
219: l_amt_funded_tbl PO_TBL_NUMBER;
220: -- Bug 16475592: Changing data type of l_func_currency_tbl from table of number
221: -- to table of varchar as the data is inserted from GL_SETS_OF_BOOKS, currency
222: -- code column which has varchar2 data type.
223: l_func_currency_tbl PO_TBL_VARCHAR20;
224:
225: x_precision NUMBER := NULL;

Line 255: GL_SETS_OF_BOOKS GLSOB

251: l_amt_ordered_tbl,l_partial_flag_tbl,l_fund_value_tbl,l_nr_tax_tbl,
252: l_rate_tbl,l_qty_funded_tbl,l_amt_funded_tbl,l_func_currency_tbl
253: FROM po_req_distributions_all d,
254: po_requisition_lines_all l,
255: GL_SETS_OF_BOOKS GLSOB
256: WHERE l.requisition_header_id = p_doc_header_id
257: AND l.requisition_line_id = d.requisition_line_id
258: AND Nvl(l.cancel_flag,'N') <> 'Y'
259: AND Nvl(l.closed_code,'OPEN') <> 'FINALLY CLOSED'

Line 281: GL_SETS_OF_BOOKS GLSOB

277: l_amt_ordered_tbl,l_partial_flag_tbl,l_fund_value_tbl,l_nr_tax_tbl,
278: l_rate_tbl,l_qty_funded_tbl,l_amt_funded_tbl,l_func_currency_tbl
279: FROM po_distributions_merge_v d,
280: po_line_locations_merge_v s,
281: GL_SETS_OF_BOOKS GLSOB
282: WHERE d.po_header_id = p_doc_header_id
283: AND d.draft_id = p_draft_id
284: AND s.draft_id = p_draft_id
285: AND s.line_location_id = d.line_location_id