DBA Data[Home] [Help]

APPS.AP_VENDOR_PUB_PKG dependencies on GL_SETS_OF_BOOKS

Line 404: l_dummy GL_SETS_OF_BOOKS.set_of_books_id%TYPE;

400: --
401: PROCEDURE Check_Valid_Sob_Id(p_sob_id IN NUMBER,
402: x_valid OUT NOCOPY BOOLEAN
403: ) IS
404: l_dummy GL_SETS_OF_BOOKS.set_of_books_id%TYPE;
405:
406: BEGIN
407: x_valid := TRUE;
408:

Line 411: FROM GL_SETS_OF_BOOKS

407: x_valid := TRUE;
408:
409: SELECT set_of_books_id
410: INTO l_dummy
411: FROM GL_SETS_OF_BOOKS
412: WHERE set_of_books_id = p_sob_id;
413:
414:
415: EXCEPTION

Line 729: FROM GL_CODE_COMBINATIONS GCC, GL_SETS_OF_BOOKS GSOB

725:
726: Begin
727: SELECT GCC.code_combination_id
728: INTO l_ccid
729: FROM GL_CODE_COMBINATIONS GCC, GL_SETS_OF_BOOKS GSOB
730: WHERE GCC.code_combination_id = p_ccid
731: AND GCC.account_type = 'L'
732: AND GCC.enabled_flag = 'Y'
733: AND GCC.detail_posting_allowed_flag = 'Y'

Line 750: FROM GL_CODE_COMBINATIONS GCC, GL_SETS_OF_BOOKS GSOB

746: ELSE
747: Begin
748: SELECT GCC.code_combination_id
749: INTO l_ccid
750: FROM GL_CODE_COMBINATIONS GCC, GL_SETS_OF_BOOKS GSOB
751: WHERE GCC.code_combination_id = p_ccid
752: AND GCC.enabled_flag = 'Y'
753: AND GCC.detail_posting_allowed_flag = 'Y'
754: AND GCC.chart_of_accounts_id = GSOB.chart_of_accounts_id