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 151: FROM gl_sets_of_books

147:
148: /* find chart of account id from set of book */
149: SELECT chart_of_accounts_id
150: INTO l_chart_of_accounts_id
151: FROM gl_sets_of_books
152: WHERE set_of_books_id = l_sob;
153:
154: /* get the all the segment array */
155: l_result := FND_FLEX_EXT.GET_SEGMENTS(

Line 240: FROM gl_sets_of_books

236:
237: /* find chart of account id from set of book */
238: SELECT chart_of_accounts_id
239: INTO l_chart_of_accounts_id
240: FROM gl_sets_of_books
241: WHERE set_of_books_id = l_sob;
242:
243: /* get the all the segment array */
244: l_result := FND_FLEX_EXT.GET_SEGMENTS(

Line 624: l_currency_code gl_sets_of_books.currency_code%TYPE;

620: --End of Comments
621: -------------------------------------------------------------------------------
622: FUNCTION get_function_currency_po(ameApprovalId IN NUMBER)
623: RETURN VARCHAR2 IS
624: l_currency_code gl_sets_of_books.currency_code%TYPE;
625:
626: BEGIN
627: SELECT gls.currency_code
628: INTO l_currency_code

Line 630: gl_sets_of_books gls,

626: BEGIN
627: SELECT gls.currency_code
628: INTO l_currency_code
629: FROM financials_system_params_all fsp,
630: gl_sets_of_books gls,
631: po_headers_merge_v phm
632: WHERE fsp.set_of_books_id = gls.set_of_books_id and
633: fsp.org_id = phm.org_id and --
634: phm.ame_approval_id = ameApprovalId;