DBA Data[Home] [Help]

APPS.PO_AME_SETUP_PVT dependencies on GL_SETS_OF_BOOKS

Line 29: l_currency_code gl_sets_of_books.currency_code%TYPE;

25: --End of Comments
26: -------------------------------------------------------------------------------
27: FUNCTION get_function_currency(reqHeaderId IN NUMBER)
28: RETURN VARCHAR2 IS
29: l_currency_code gl_sets_of_books.currency_code%TYPE;
30:
31: BEGIN
32: SELECT gls.currency_code
33: INTO l_currency_code

Line 35: gl_sets_of_books gls,

31: BEGIN
32: SELECT gls.currency_code
33: INTO l_currency_code
34: FROM financials_system_params_all fsp,
35: gl_sets_of_books gls,
36: po_requisition_headers_all prh
37: WHERE fsp.set_of_books_id = gls.set_of_books_id and
38: fsp.org_id = prh.org_id and --
39: prh.requisition_header_id = reqHeaderId;

Line 138: FROM gl_sets_of_books

134:
135: /* find chart of account id from set of book */
136: SELECT chart_of_accounts_id
137: INTO l_chart_of_accounts_id
138: FROM gl_sets_of_books
139: WHERE set_of_books_id = l_sob;
140:
141: /* get the all the segment array */
142: l_result := FND_FLEX_EXT.GET_SEGMENTS(