APPS.ZX_MIGRATE_AR_TAX_DEF dependencies on FND_PROFILE_OPTIONS

Line 8763: from fnd_profile_options fpo

8759: select DISTINCT
8760: fpov2.profile_option_value
8761: from fnd_profile_option_values fpov1, fnd_profile_option_values fpov2
8762: where fpov1.profile_option_id = (select fpo.profile_option_id
8763: from fnd_profile_options fpo
8764: where fpo.profile_option_name = 'ZX_ALLOW_MANUAL_TAX_LINES')
8765: and fpov1.level_id = 10003
8766: and fpov1.application_id = 235
8767: AND fpov2.profile_option_id = (select fpo.profile_option_id

Line 8768: from fnd_profile_options fpo

8764: where fpo.profile_option_name = 'ZX_ALLOW_MANUAL_TAX_LINES')
8765: and fpov1.level_id = 10003
8766: and fpov1.application_id = 235
8767: AND fpov2.profile_option_id = (select fpo.profile_option_id
8768: from fnd_profile_options fpo
8769: where fpo.profile_option_name = 'ORG_ID')
8770: and fpov2.level_id = 10003
8771: and fpov2.application_id = 0
8772: AND fpov2.level_value=fpov1.level_value

Line 8780: from fnd_profile_options fpo

8776: select DISTINCT
8777: fpov2.profile_option_value
8778: from fnd_profile_option_values fpov1, fnd_profile_option_values fpov2
8779: where fpov1.profile_option_id = (select fpo.profile_option_id
8780: from fnd_profile_options fpo
8781: where fpo.profile_option_name = 'ZX_ALLOW_MANUAL_TAX_LINES')
8782: and fpov1.level_id = 10003
8783: and fpov1.application_id = 235
8784: AND fpov2.profile_option_id = (select fpo.profile_option_id

Line 8785: from fnd_profile_options fpo

8781: where fpo.profile_option_name = 'ZX_ALLOW_MANUAL_TAX_LINES')
8782: and fpov1.level_id = 10003
8783: and fpov1.application_id = 235
8784: AND fpov2.profile_option_id = (select fpo.profile_option_id
8785: from fnd_profile_options fpo
8786: where fpo.profile_option_name = 'ORG_ID')
8787: and fpov2.level_id = 10003
8788: and fpov2.application_id = 0
8789: AND fpov2.level_value=fpov1.level_value