APPS.QP_DEFAULT_PRICE_LIST dependencies on QP_CURRENCY_LISTS_B

Line 235: --and qp_currency_lists_b.base_currency_code is a notnull column

231: -- is not found then create it.
232: if nvl(fnd_profile.value('QP_MULTI_CURRENCY_INSTALLED'), 'N') = 'Y'
233: --added for moac now defaulted currency_code can be null
234: --when the default org_id is not set as the OM setofbooks will be null
235: --and qp_currency_lists_b.base_currency_code is a notnull column
236: --and the insert below will fail
237: and g_PRICE_LIST_rec.currency_code IS NOT NULL then
238: BEGIN
239: select currency_header_id

Line 254: SELECT QP_CURRENCY_LISTS_B_S.NEXTVAL

250: declare
251: ll_currency_header_id number;
252: begin
253: -- Get next currency_header_id
254: SELECT QP_CURRENCY_LISTS_B_S.NEXTVAL
255: INTO ll_currency_header_id
256: FROM dual;
257:
258: -- Insert one record into qp_currency_lists

Line 259: INSERT INTO QP_CURRENCY_LISTS_B

255: INTO ll_currency_header_id
256: FROM dual;
257:
258: -- Insert one record into qp_currency_lists
259: INSERT INTO QP_CURRENCY_LISTS_B
260: ( ATTRIBUTE1
261: , ATTRIBUTE10
262: , ATTRIBUTE11
263: , ATTRIBUTE12