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 105: GL_SETS_OF_BOOKS GSB

101: INTO x_base_currency,
102: x_po_currency
103: FROM PO_HEADERS_ALL POH, -- Bug 3012328 (Changed to all table so that this does not fail for GA's)
104: FINANCIALS_SYSTEM_PARAMS_ALL FSP, -- Bug 5221311 Changed to all table
105: GL_SETS_OF_BOOKS GSB
106: WHERE POH.po_header_id = x_object_id
107: AND FSP.set_of_books_id = GSB.set_of_books_id
108: AND FSP.org_id = POH.org_id; --< R12 MOAC>
109:

Line 118: x_currency_code gl_sets_of_books.currency_code%TYPE;

114:
115: --
116: FUNCTION get_base_currency(p_org_id po_system_parameters_all.org_id%TYPE)
117: return VARCHAR2 IS
118: x_currency_code gl_sets_of_books.currency_code%TYPE;
119: BEGIN
120:
121: SELECT gsb.currency_code
122: INTO x_currency_code

Line 124: gl_sets_of_books gsb

120:
121: SELECT gsb.currency_code
122: INTO x_currency_code
123: FROM financials_system_params_all fsp,
124: gl_sets_of_books gsb
125: WHERE fsp.set_of_books_id = gsb.set_of_books_id
126: AND fsp.org_id = p_org_id;
127:
128: return(x_currency_code);

Line 145: GL_SETS_OF_BOOKS GSB

141:
142: SELECT GSB.currency_code
143: INTO x_currency_code
144: FROM FINANCIALS_SYSTEM_PARAMETERS FSP,
145: GL_SETS_OF_BOOKS GSB
146: WHERE FSP.set_of_books_id = GSB.set_of_books_id;
147:
148: return(x_currency_code);
149: