APPS.PO_APPROVAL_ACTION dependencies on GL_SETS_OF_BOOKS

Line 240: GL_SETS_OF_BOOKS SOB

236: (SELECT
237: po_core_s.get_conversion_rate (FSP.set_of_books_id, PORL.currency_code, PORL.rate_date, PORL.rate_type)
238: FROM
239: FINANCIALS_SYSTEM_PARAMS_ALL FSP,
240: GL_SETS_OF_BOOKS SOB
241: WHERE
242: nvl(FSP.org_id, -9999) = nvl(PORL.org_id, -9999) AND
243: SOB.set_of_books_id = FSP.set_of_books_id AND
244: SOB.currency_code <> PORL.currency_code AND

Line 496: GL_SETS_OF_BOOKS SOB

492: l_online_report_id,l_last_update_login,l_user_id, sysdate,
493: l_user_id,sysdate,PRL.line_num,0,0,l_sequence,
494: 'Line #' ||PRL.line_num||' '||l_msg_text
495: FROM PO_REQUISITION_LINES PRL, FINANCIALS_SYSTEM_PARAMETERS FSP,
496: GL_SETS_OF_BOOKS SOB
497: WHERE PRL.requisition_header_id = l_document_id AND
498: nvl(PRL.cancel_flag, 'N') = 'N' AND nvl(PRL.closed_code, 'OPEN') <>
499: 'FINALLY CLOSED' AND SOB.set_of_books_id = FSP.set_of_books_id AND
500: SOB.currency_code <> PRL.currency_code AND ( PRL.rate is null

Line 562: , GL_SETS_OF_BOOKS GSOB

558: select 'find if the GL date is not within Open period'
559: from
560: GL_PERIOD_STATUSES PS1
561: , GL_PERIOD_STATUSES PS2
562: , GL_SETS_OF_BOOKS GSOB
563: WHERE PS1.application_id = 101
564: AND PS1.set_of_books_id = FSP.set_of_books_id
565: AND PS1.closing_status IN ('O','F')
566: AND trunc(nvl(PRD.GL_ENCUMBERED_DATE,PS1.start_date))