DBA Data[Home] [Help]

APPS.PO_WF_PO_RULE_ACC dependencies on GL_SETS_OF_BOOKS

Line 182: , GL_SETS_OF_BOOKS emp_sob

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:
185: WHERE hrecv.person_id = x_requester_id
186: AND hrecv.business_group_id = fsp.business_group_id

Line 183: , GL_SETS_OF_BOOKS org_sob

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:
185: WHERE hrecv.person_id = x_requester_id
186: AND hrecv.business_group_id = fsp.business_group_id
187: AND org_sob.set_of_books_id = fsp.set_of_books_id

Line 448: gl_sets_of_books gls

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
450: fs.id_flex_num = gls.chart_of_accounts_id and
451: fs.id_flex_code = 'GL#' and
452: fs.application_id = 101 AND

Line 483: gl_sets_of_books gls

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
485:
486: --< Shared Proc FPJ Start >
487: -- NVL is required for the single-org instance case.

Line 693: gl_sets_of_books gls

689: MTL_DEFAULT_CATEGORY_SETS MDCS,
690: MTL_CATEGORIES MC,
691: --< Shared Proc FPJ End >
692:
693: gl_sets_of_books gls
694:
695: WHERE PREA.rule_type = 'ITEM CATEGORY'
696: AND PREA.RULE_VALUE_ID = x_category_id
697: