APPS.PO_CORE_S2 dependencies on GL_SETS_OF_BOOKS

Line 32: GL_SETS_OF_BOOKS GSB

28: --Req Currency
29: SELECT GSB.currency_code
30: INTO x_base_currency
31: FROM FINANCIALS_SYSTEM_PARAMETERS FSP,
32: GL_SETS_OF_BOOKS GSB
33: WHERE FSP.set_of_books_id = GSB.set_of_books_id
34: AND FSP.ORG_ID=p_org_id;
35:
36: EXCEPTION

Line 78: GL_SETS_OF_BOOKS GSB

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>
82:

Line 91: x_currency_code gl_sets_of_books.currency_code%TYPE;

87:
88: --
89: FUNCTION get_base_currency(p_org_id po_system_parameters_all.org_id%TYPE)
90: return VARCHAR2 IS
91: x_currency_code gl_sets_of_books.currency_code%TYPE;
92: BEGIN
93:
94: SELECT gsb.currency_code
95: INTO x_currency_code

Line 97: gl_sets_of_books gsb

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:
101: return(x_currency_code);

Line 118: GL_SETS_OF_BOOKS GSB

114:
115: SELECT GSB.currency_code
116: INTO x_currency_code
117: FROM FINANCIALS_SYSTEM_PARAMETERS FSP,
118: GL_SETS_OF_BOOKS GSB
119: WHERE FSP.set_of_books_id = GSB.set_of_books_id;
120:
121: return(x_currency_code);
122: