100: FROM per_workforce_current_x hrecv, --R12 CWK Enhancement
101:
102: --< Shared Proc FPJ Start >
103: --financials_system_parameters fsp
104: financials_system_params_all fsp
105: --< Shared Proc FPJ End >
106: , GL_SETS_OF_BOOKS emp_sob
107: , GL_SETS_OF_BOOKS org_sob
108:
347: from FND_ID_FLEX_SEGMENTS fs,
348:
349: --< Shared Proc FPJ Start >
350: --financials_system_parameters fsp,
351: financials_system_params_all fsp,
352: --< Shared Proc FPJ End >
353:
354: gl_sets_of_books gls
355: where fsp.set_of_books_id = gls.set_of_books_id and
382: into l_chart_of_accounts_id
383:
384: --< Shared Proc FPJ Start >
385: --from financials_system_parameters fsp,
386: FROM financials_system_params_all fsp,
387: --< Shared Proc FPJ End >
388:
389: gl_sets_of_books gls
390: where fsp.set_of_books_id = gls.set_of_books_id AND
588: fnd_id_flex_segments_vl FFSV,
589:
590: --< Shared Proc FPJ Start >
591: --financials_system_parameters fsp,
592: financials_system_params_all fsp,
593: MTL_CATEGORIES_KFV MCK,
594: MTL_CATEGORY_SETS MCS,
595: MTL_DEFAULT_CATEGORY_SETS MDCS,
596: MTL_CATEGORIES MC,