APPS.PO_CREATE_ISO dependencies on GL_SETS_OF_BOOKS

Line 533: FROM gl_sets_of_books glsob,

529:
530: --Bug 10037733
531: SELECT currency_code
532: INTO l_Source_Currency_Code
533: FROM gl_sets_of_books glsob,
534: org_organization_definitions ood
535: WHERE glsob.set_of_books_id = ood.set_of_books_id
536: AND ood.organization_id = l_source_org_id;
537:

Line 543: gl_sets_of_books gl

539: select currency_code
540: into l_dest_currency_code
541: from
542: financials_system_parameters fsp,
543: gl_sets_of_books gl
544: where gl.set_of_books_id = fsp.set_of_books_id
545: --#bug 12816938 add org condition to return single row for multi org.
546: and fsp.org_id = l_org_id;
547:

Line 819: /* get currency_code form GL sets of books,This should

815: l_ac_id out NOCOPY number,
816: l_ir_id out NOCOPY number) IS
817:
818: BEGIN
819: /* get currency_code form GL sets of books,This should
820: return one row, if not return error and exit subroutine */
821:
822: BEGIN
823:

Line 828: FROM GL_SETS_OF_BOOKS GLSOB,

824: Fnd_File.Put_Line(FND_FILE.LOG, 'Selecting Currency Code');
825:
826: SELECT glsob.CURRENCY_CODE
827: INTO l_currency_code
828: FROM GL_SETS_OF_BOOKS GLSOB,
829: FINANCIALS_SYSTEM_PARAMS_ALL FSP
830: WHERE GLSOB.SET_OF_BOOKS_ID=FSP.SET_OF_BOOKS_ID
831: AND nvl(FSP.org_id,-1) = l_op_unit_id;
832: