DBA Data[Home] [Help]

APPS.PO_ACCOUNTING_GRP dependencies on GL_SETS_OF_BOOKS

Line 69: l_coa_id GL_SETS_OF_BOOKS.chart_of_accounts_id%TYPE;

65: l_api_version CONSTANT NUMBER := 1.0;
66: l_api_name CONSTANT VARCHAR2(30) := 'BUILD_OFFSET_ACCOUNT';
67:
68: l_auto_offset_method PO_SYSTEM_PARAMETERS.auto_offset_method%TYPE;
69: l_coa_id GL_SETS_OF_BOOKS.chart_of_accounts_id%TYPE;
70: l_qualifier_segment_num NUMBER;
71: l_base_segments FND_FLEX_EXT.SEGMENTARRAY;
72: l_overlay_segments FND_FLEX_EXT.SEGMENTARRAY;
73: l_result_segments FND_FLEX_EXT.SEGMENTARRAY;

Line 108: gl_sets_of_books SOB

104: INTO l_auto_offset_method,
105: l_coa_id
106: FROM po_system_parameters_all PSP,
107: financials_system_params_all FSP,
108: gl_sets_of_books SOB
109: WHERE NVL(PSP.org_id,-99) = NVL(p_org_id,-99)
110: AND NVL(FSP.org_id,-99) = NVL(p_org_id,-99)
111: AND FSP.set_of_books_id = SOB.set_of_books_id; -- JOIN
112: