176: FROM per_workforce_current_x hrecv, --R12 CWK Enhancement
177:
178: --< Shared Proc FPJ Start >
179: --financials_system_parameters fsp
180: financials_system_params_all fsp
181: --< Shared Proc FPJ End >
182: , GL_SETS_OF_BOOKS emp_sob
183: , GL_SETS_OF_BOOKS org_sob
184:
441: from FND_ID_FLEX_SEGMENTS fs,
442:
443: --< Shared Proc FPJ Start >
444: --financials_system_parameters fsp,
445: financials_system_params_all fsp,
446: --< Shared Proc FPJ End >
447:
448: gl_sets_of_books gls
449: where fsp.set_of_books_id = gls.set_of_books_id and
476: into l_chart_of_accounts_id
477:
478: --< Shared Proc FPJ Start >
479: --from financials_system_parameters fsp,
480: FROM financials_system_params_all fsp,
481: --< Shared Proc FPJ End >
482:
483: gl_sets_of_books gls
484: where fsp.set_of_books_id = gls.set_of_books_id AND
682: fnd_id_flex_segments_vl FFSV,
683:
684: --< Shared Proc FPJ Start >
685: --financials_system_parameters fsp,
686: financials_system_params_all fsp,
687: MTL_CATEGORIES_KFV MCK,
688: MTL_CATEGORY_SETS MCS,
689: MTL_DEFAULT_CATEGORY_SETS MDCS,
690: MTL_CATEGORIES MC,