APPS.PO_INTERFACE_S dependencies on GL_SETS_OF_BOOKS

Line 83: (currency_code gl_sets_of_books.currency_code%type,

79: );
80:
81: /* Type declaration for System Parameters structure */
82: TYPE system_parameters_type IS RECORD
83: (currency_code gl_sets_of_books.currency_code%type,
84: coa_id number,
85: po_encumbrance_flag varchar2(1),
86: req_encumbrance_flag varchar2(1),
87: sob_id number,

Line 7248: , GL_SETS_OF_BOOKS GSOB

7244: SELECT PS1.period_name
7245: INTO params.period_name
7246: FROM GL_PERIOD_STATUSES PS1
7247: , GL_PERIOD_STATUSES PS2
7248: , GL_SETS_OF_BOOKS GSOB
7249: WHERE PS1.application_id = x_gl_appl_id
7250: AND PS1.set_of_books_id = params.sob_id
7251: AND PS1.adjustment_period_flag = 'N'
7252: AND trunc(sysdate) BETWEEN trunc(PS1.start_date)

Line 9066: l_req_ou_currency_code GL_SETS_OF_BOOKS.currency_code%TYPE; -- Bug 3794198

9062: l_ext_precision FND_CURRENCIES.extended_precision%TYPE;
9063: l_min_acct_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
9064:
9065: l_req_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;
9066: l_req_ou_currency_code GL_SETS_OF_BOOKS.currency_code%TYPE; -- Bug 3794198
9067: l_req_unit_price PO_REQUISITION_LINES_ALL.unit_price%TYPE;
9068: l_req_currency_unit_price PO_REQUISITION_LINES_ALL.currency_unit_price%TYPE;
9069: l_req_amount PO_REQUISITION_LINES_ALL.amount%TYPE;
9070: l_req_currency_amount PO_REQUISITION_LINES_ALL.currency_amount%TYPE;

Line 9137: -- Bug 3794198: Join to financials_system_params_all and gl_sets_of_books to

9133:
9134: ELSE -- ( p_interface_source_code NOT IN ('SOURCING','CONSUMPTION_ADVICE') )
9135:
9136: -- Retrieve information from the backing Requisition Line.
9137: -- Bug 3794198: Join to financials_system_params_all and gl_sets_of_books to
9138: -- retrieve the value of l_req_ou_currency_code, the functional currency of ROU
9139: SELECT PRL.currency_code
9140: , GSB.currency_code
9141: , PRL.unit_price

Line 9153: gl_sets_of_books GSB

9149: , l_req_amount
9150: , l_req_currency_amount
9151: FROM po_requisition_lines_all PRL,
9152: financials_system_params_all FSP,
9153: gl_sets_of_books GSB
9154: WHERE PRL.requisition_line_id = p_requisition_line_id
9155: AND nvl(PRL.org_id, -99) = nvl(FSP.org_id, -99)
9156: AND FSP.set_of_books_id = GSB.set_of_books_id;
9157:

Line 14809: l_req_ou_sob_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;

14805: x_rate OUT NOCOPY NUMBER
14806: )
14807: IS
14808:
14809: l_req_ou_sob_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;
14810: l_po_ou_sob_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;
14811: l_inverse_rate_display_flag VARCHAR2(1) := 'N';
14812: l_display_rate NUMBER;
14813: l_progress VARCHAR2(3) := '000';

Line 14810: l_po_ou_sob_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;

14806: )
14807: IS
14808:
14809: l_req_ou_sob_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;
14810: l_po_ou_sob_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;
14811: l_inverse_rate_display_flag VARCHAR2(1) := 'N';
14812: l_display_rate NUMBER;
14813: l_progress VARCHAR2(3) := '000';
14814: l_rate_type PO_HEADERS_INTERFACE.rate_type%TYPE;