DBA Data[Home] [Help]

APPS.ZX_PRD_OPTIONS_MIGRATE_PKG dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 183: FINANCIALS_SYSTEM_PARAMS_ALL fin

179: ap_system_options.tax_minimum_accountable_unit,
180: ap_system_options.use_tax_classification_flag,
181: ap_system_options.home_country_default_flag
182: FROM AP_SYSTEM_PARAMETERS_ALL sys,
183: FINANCIALS_SYSTEM_PARAMS_ALL fin
184: WHERE decode(l_multi_org_flag,'N',l_org_id,fin.org_id(+)) = decode(l_multi_org_flag,'N',l_org_id,sys.org_id)
185: AND NOT EXISTS (SELECT 1
186: FROM ZX_PRODUCT_OPTIONS_ALL prd
187: WHERE prd.ORG_ID = decode(l_multi_org_flag,'N',l_org_id,sys.org_id)

Line 475: FINANCIALS_SYSTEM_PARAMS_ALL fin

471: ar_system_options.use_tax_classification_flag,
472: ar_system_options.home_country_default_flag,
473: ar_system_options.sales_tax_geocode
474: FROM AR_SYSTEM_PARAMETERS_ALL sys,
475: FINANCIALS_SYSTEM_PARAMS_ALL fin
476: WHERE decode(l_multi_org_flag,'N',l_org_id,fin.org_id(+)) = decode(l_multi_org_flag,'N',l_org_id,sys.org_id)
477: AND NOT EXISTS (SELECT 1
478: FROM ZX_PRODUCT_OPTIONS_ALL prd
479: WHERE prd.ORG_ID = decode(l_multi_org_flag,'N',l_org_id,sys.org_id)

Line 703: FINANCIALS_SYSTEM_PARAMS_ALL fin

699: po_system_options.tax_minimum_accountable_unit,
700: po_system_options.use_tax_classification_flag,
701: po_system_options.home_country_default_flag
702: FROM PO_SYSTEM_PARAMETERS_ALL sys,
703: FINANCIALS_SYSTEM_PARAMS_ALL fin
704: WHERE decode(l_multi_org_flag,'N',l_org_id,fin.org_id(+))= decode(l_multi_org_flag,'N',l_org_id,sys.org_id)
705: AND NOT EXISTS (SELECT 1
706: FROM ZX_PRODUCT_OPTIONS_ALL prd
707: WHERE prd.ORG_ID = decode(l_multi_org_flag,'N',l_org_id,sys.org_id)