DBA Data[Home] [Help]

APPS.CN_COMP_PLAN_XMLCOPY_PVT dependencies on GL_SETS_OF_BOOKS

Line 309: FROM gl_sets_of_books glb, cn_repositories r, gl_code_combinations glc

305: l_pe_counter NUMBER;
306:
307: CURSOR c_expense_account_id (p_exp_acc_desc VARCHAR2) IS
308: SELECT code_combination_id
309: FROM gl_sets_of_books glb, cn_repositories r, gl_code_combinations glc
310: WHERE account_type = 'E'
311: AND glb.chart_of_accounts_id = glc.chart_of_accounts_id
312: AND r.set_of_books_id = glb.set_of_books_id
313: AND SEGMENT1||'-'||SEGMENT2||'-'||SEGMENT3||'-'||SEGMENT4||'-'||SEGMENT5 = p_exp_acc_desc

Line 318: FROM gl_sets_of_books glb, cn_repositories r, gl_code_combinations glc

314: AND r.org_id = p_org_id;
315:
316: CURSOR c_liab_account_id (p_liab_acc_desc VARCHAR2) IS
317: SELECT code_combination_id
318: FROM gl_sets_of_books glb, cn_repositories r, gl_code_combinations glc
319: WHERE account_type = 'L'
320: AND glb.chart_of_accounts_id = glc.chart_of_accounts_id
321: AND r.set_of_books_id = glb.set_of_books_id
322: AND SEGMENT1||'-'||SEGMENT2||'-'||SEGMENT3||'-'||SEGMENT4||'-'||SEGMENT5 = p_liab_acc_desc