DBA Data[Home] [Help]

APPS.PO_REQIMP_S dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 46: FROM gl_sets_of_books glsob,org_organization_definitions ood,po_system_parameters psp

42: Select round(gl_currency_api.get_closest_rate_sql(x_set_of_books_id,glsob.currency_code,
43: trunc(nvl(nvl(nvl(x_rate_date,x_gl_date),x_creation_date),sysdate)),
44: psp.DEFAULT_RATE_TYPE, 30),10)
45: INTO x_list_price_conv_temp
46: FROM gl_sets_of_books glsob,org_organization_definitions ood,po_system_parameters psp
47: WHERE x_currency_code <> glsob.currency_code
48: AND glsob.set_of_books_id = ood.set_of_books_id
49: AND ood.organization_id = x_source_org_id
50: AND psp.DEFAULT_RATE_TYPE in (select DEFAULT_RATE_TYPE from po_system_parameters);