APPS.PO_WF_PO_RULE_ACC dependencies on GL_SETS_OF_BOOKS

Line 106: , GL_SETS_OF_BOOKS emp_sob

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

Line 107: , GL_SETS_OF_BOOKS org_sob

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:
109: WHERE hrecv.person_id = x_requester_id
110: AND hrecv.business_group_id = fsp.business_group_id
111: AND org_sob.set_of_books_id = fsp.set_of_books_id

Line 354: gl_sets_of_books gls

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
356: fs.id_flex_num = gls.chart_of_accounts_id and
357: fs.id_flex_code = 'GL#' and
358: fs.application_id = 101 AND

Line 389: gl_sets_of_books gls

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
391:
392: --< Shared Proc FPJ Start >
393: -- NVL is required for the single-org instance case.

Line 599: gl_sets_of_books gls

595: MTL_DEFAULT_CATEGORY_SETS MDCS,
596: MTL_CATEGORIES MC,
597: --< Shared Proc FPJ End >
598:
599: gl_sets_of_books gls
600:
601: WHERE PREA.rule_type = 'ITEM CATEGORY'
602: AND PREA.RULE_VALUE_ID = x_category_id
603: