DBA Data[Home] [Help]

APPS.CN_COMP_PLAN_XMLCOPY_PVT dependencies on GL_SETS_OF_BOOKS

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

312: v_pe_tbl v_pe_collection;
313:
314: CURSOR c_expense_account_id (p_exp_acc_desc VARCHAR2) IS
315: SELECT code_combination_id
316: FROM gl_sets_of_books glb, cn_repositories r, gl_code_combinations glc
317: WHERE account_type = 'E'
318: AND glb.chart_of_accounts_id = glc.chart_of_accounts_id
319: AND r.set_of_books_id = glb.set_of_books_id
320: AND SEGMENT1||'-'||SEGMENT2||'-'||SEGMENT3||'-'||SEGMENT4||'-'||SEGMENT5 = p_exp_acc_desc

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

321: AND r.org_id = p_org_id;
322:
323: CURSOR c_liab_account_id (p_liab_acc_desc VARCHAR2) IS
324: SELECT code_combination_id
325: FROM gl_sets_of_books glb, cn_repositories r, gl_code_combinations glc
326: WHERE account_type = 'L'
327: AND glb.chart_of_accounts_id = glc.chart_of_accounts_id
328: AND r.set_of_books_id = glb.set_of_books_id
329: AND SEGMENT1||'-'||SEGMENT2||'-'||SEGMENT3||'-'||SEGMENT4||'-'||SEGMENT5 = p_liab_acc_desc