APPS.POR_AMENDMENT_PKG dependencies on GL_SETS_OF_BOOKS

Line 5810: l_req_ou_sob_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;

5806: x_destination_context PO_REQUISITION_LINES_ALL.destination_context%TYPE;
5807: x_vendor_id PO_REQUISITION_LINES_ALL.vendor_id%TYPE;
5808: x_requesting_ou_id PO_REQUISITION_HEADERS_ALL.org_id%TYPE;
5809:
5810: l_req_ou_sob_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;
5811: l_po_ou_sob_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;
5812: l_display_rate NUMBER;
5813: l_rate_type PO_HEADERS_INTERFACE.rate_type%TYPE;
5814:

Line 5811: l_po_ou_sob_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;

5807: x_vendor_id PO_REQUISITION_LINES_ALL.vendor_id%TYPE;
5808: x_requesting_ou_id PO_REQUISITION_HEADERS_ALL.org_id%TYPE;
5809:
5810: l_req_ou_sob_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;
5811: l_po_ou_sob_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;
5812: l_display_rate NUMBER;
5813: l_rate_type PO_HEADERS_INTERFACE.rate_type%TYPE;
5814:
5815:

Line 5915: gl_sets_of_books sob,

5911: x_sob_id,
5912: x_receiving_flag,
5913: x_expense_accrual_code
5914: FROM financials_system_parameters fsp,
5915: gl_sets_of_books sob,
5916: po_system_parameters psp,
5917: rcv_parameters rcv
5918: WHERE fsp.set_of_books_id = sob.set_of_books_id
5919: AND rcv.organization_id (+) = fsp.inventory_organization_id;

Line 6027: , GL_SETS_OF_BOOKS GSOB

6023: SELECT PS1.period_name
6024: INTO x_period_name
6025: FROM GL_PERIOD_STATUSES PS1
6026: , GL_PERIOD_STATUSES PS2
6027: , GL_SETS_OF_BOOKS GSOB
6028: WHERE PS1.application_id = x_gl_appl_id
6029: AND PS1.set_of_books_id = x_sob_id
6030: AND PS1.adjustment_period_flag = 'N'
6031: AND trunc(sysdate) BETWEEN trunc(PS1.start_date)