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 535: GL_SETS_OF_BOOKS SOB

531: l_online_report_id,l_last_update_login,l_user_id, sysdate,
532: l_user_id,sysdate,PRL.line_num,0,0,l_sequence,
533: 'Line #' ||PRL.line_num||' '||l_msg_text
534: FROM po_requisition_lines_clm_v PRL, FINANCIALS_SYSTEM_PARAMETERS FSP,
535: GL_SETS_OF_BOOKS SOB
536: WHERE PRL.requisition_header_id = l_document_id AND
537: nvl(PRL.cancel_flag, 'N') = 'N' AND nvl(PRL.closed_code, 'OPEN') <>
538: 'FINALLY CLOSED' AND SOB.set_of_books_id = FSP.set_of_books_id AND
539: SOB.currency_code <> PRL.currency_code AND ( PRL.rate is null

Line 604: , GL_SETS_OF_BOOKS GSOB

600: select 'find if the GL date is not within Open period'
601: from
602: GL_PERIOD_STATUSES PS1
603: , GL_PERIOD_STATUSES PS2
604: , GL_SETS_OF_BOOKS GSOB
605: WHERE PS1.application_id = 101
606: AND PS1.set_of_books_id = FSP.set_of_books_id
607: -- bug 5498063
608: AND (( l_validate_gl_period IN ('Y','R') -- GL Date Project Changes R- Redefault