APPS.AP_VENDOR_PUB_PKG dependencies on GL_SETS_OF_BOOKS

Line 503: l_dummy GL_SETS_OF_BOOKS.set_of_books_id%TYPE;

499: --
500: PROCEDURE Check_Valid_Sob_Id(p_sob_id IN NUMBER,
501: x_valid OUT NOCOPY BOOLEAN
502: ) IS
503: l_dummy GL_SETS_OF_BOOKS.set_of_books_id%TYPE;
504:
505: BEGIN
506: x_valid := TRUE;
507:

Line 510: FROM GL_SETS_OF_BOOKS

506: x_valid := TRUE;
507:
508: SELECT set_of_books_id
509: INTO l_dummy
510: FROM GL_SETS_OF_BOOKS
511: WHERE set_of_books_id = p_sob_id;
512:
513:
514: EXCEPTION

Line 862: FROM GL_CODE_COMBINATIONS GCC, GL_SETS_OF_BOOKS GSOB

858:
859: Begin
860: SELECT GCC.code_combination_id
861: INTO l_ccid
862: FROM GL_CODE_COMBINATIONS GCC, GL_SETS_OF_BOOKS GSOB
863: WHERE GCC.code_combination_id = p_ccid
864: AND GCC.account_type = 'L'
865: AND GCC.enabled_flag = 'Y'
866: AND GCC.detail_posting_allowed_flag = 'Y'

Line 883: FROM GL_CODE_COMBINATIONS GCC, GL_SETS_OF_BOOKS GSOB

879: ELSE
880: Begin
881: SELECT GCC.code_combination_id
882: INTO l_ccid
883: FROM GL_CODE_COMBINATIONS GCC, GL_SETS_OF_BOOKS GSOB
884: WHERE GCC.code_combination_id = p_ccid
885: AND GCC.enabled_flag = 'Y'
886: AND GCC.detail_posting_allowed_flag = 'Y'
887: AND GCC.chart_of_accounts_id = GSOB.chart_of_accounts_id