DBA Data[Home] [Help]

APPS.PO_CORE_S2 dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 77: FINANCIALS_SYSTEM_PARAMS_ALL FSP, -- Bug 5221311 Changed to all table

73: POH.currency_code
74: INTO x_base_currency,
75: x_po_currency
76: FROM PO_HEADERS_ALL POH, -- Bug 3012328 (Changed to all table so that this does not fail for GA's)
77: FINANCIALS_SYSTEM_PARAMS_ALL FSP, -- Bug 5221311 Changed to all table
78: GL_SETS_OF_BOOKS GSB
79: WHERE POH.po_header_id = x_object_id
80: AND FSP.set_of_books_id = GSB.set_of_books_id
81: AND FSP.org_id = POH.org_id; --< R12 MOAC>

Line 96: FROM financials_system_params_all fsp,

92: BEGIN
93:
94: SELECT gsb.currency_code
95: INTO x_currency_code
96: FROM financials_system_params_all fsp,
97: gl_sets_of_books gsb
98: WHERE fsp.set_of_books_id = gsb.set_of_books_id
99: AND fsp.org_id = p_org_id;
100: