APPS.ZX_SECURITY SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 43

                      (select parent_first_pty_org_id, tax_regime_code
                       from ZX_SUBSCRIPTION_DETAILS
                       where view_options_code in (''NONE'',''VFC'',''VFR'')
                         and SYS_CONTEXT(''my_ctx'',''EFFECTIVEDATE'') between effective_from and
                         nvl(effective_to, SYS_CONTEXT(''my_ctx'',''EFFECTIVEDATE'')) and first_pty_org_id = nvl(SYS_CONTEXT(''my_ctx'',''FIRSTPTYORGID''),-999)) ';

Line: 73

                      (select decode(opt.exception_option_code, ''OWN_ONLY'', ru.first_pty_org_id, -99),
                            ru.tax_regime_code
                       from ZX_SUBSCRIPTION_OPTIONS opt,
                            ZX_REGIMES_USAGES ru
                       where  ru.regime_usage_id = opt.regime_usage_id
                         and SYS_CONTEXT(''my_ctx'',''EFFECTIVEDATE'') between opt.effective_from and
			 nvl(opt.effective_to, SYS_CONTEXT(''my_ctx'',''EFFECTIVEDATE'')) and ru.first_pty_org_id = nvl(SYS_CONTEXT(''my_ctx'',''FIRSTPTYORGID''),-999) )';

Line: 127

                        (select det.parent_first_pty_org_id, det.tax_regime_code
                         from ZX_SUBSCRIPTION_DETAILS det,
                              ZX_FIRST_PARTY_ORGANIZATIONS_V ptp
                         where det.first_pty_org_id = ptp.party_tax_profile_id)
                     or content_owner_id = -99';

Line: 134

                        (select det.parent_first_pty_org_id, det.tax_regime_code
                         from ZX_SUBSCRIPTION_DETAILS det,
                              ZX_FIRST_PARTY_ORGANIZATIONS_V ptp
                         where det.first_pty_org_id = ptp.party_tax_profile_id)';

Line: 162

                        (select decode(opt.exception_option_code, ''OWN_ONLY'', ru.first_pty_org_id, -99), ru.tax_regime_code
                         from ZX_SUBSCRIPTION_OPTIONS opt,
                              ZX_REGIMES_USAGES ru,
                              ZX_FIRST_PARTY_ORGANIZATIONS_V ptp
                         where ru.first_pty_org_id = ptp.party_tax_profile_id
                           and ru.regime_usage_id  = opt.regime_usage_id)
                     or content_owner_id = -99';

Line: 171

                        (select decode(opt.exception_option_code, ''OWN_ONLY'', ru.first_pty_org_id, -99), ru.tax_regime_code
                         from ZX_SUBSCRIPTION_OPTIONS opt,
                              ZX_REGIMES_USAGES ru,
                              ZX_FIRST_PARTY_ORGANIZATIONS_V ptp
                         where ru.first_pty_org_id = ptp.party_tax_profile_id
                           and ru.regime_usage_id  = opt.regime_usage_id)';

Line: 198

                        (select parent_first_pty_org_id, tax_regime_code
                         from ZX_SUBSCRIPTION_DETAILS det,
                              ZX_FIRST_PARTY_ORGANIZATIONS_V ptp
                         where det.first_pty_org_id = ptp.party_tax_profile_id
                           and det.view_options_code = ''VFC'')
                    or content_owner_id = -99';

Line: 206

                        (select parent_first_pty_org_id, tax_regime_code
                         from ZX_SUBSCRIPTION_DETAILS det,
                              ZX_FIRST_PARTY_ORGANIZATIONS_V ptp
                         where det.first_pty_org_id = ptp.party_tax_profile_id
                           and det.view_options_code = ''VFC'')';

Line: 233

                        (select ru.first_pty_org_id, ru.tax_regime_code
                         from ZX_SUBSCRIPTION_OPTIONS opt,
                              ZX_REGIMES_USAGES ru,
                              ZX_FIRST_PARTY_ORGANIZATIONS_V ptp
                         where ru.first_pty_org_id = ptp.party_tax_profile_id
                           and ru.regime_usage_id  = opt.regime_usage_id
                           and opt.exception_option_code = ''OWN_ONLY'')
                    or content_owner_id = -99';

Line: 243

                        (select ru.first_pty_org_id, ru.tax_regime_code
                         from ZX_SUBSCRIPTION_OPTIONS opt,
                              ZX_REGIMES_USAGES ru,
                              ZX_FIRST_PARTY_ORGANIZATIONS_V ptp
                         where ru.first_pty_org_id = ptp.party_tax_profile_id
                           and ru.regime_usage_id  = opt.regime_usage_id
                           and and opt.exception_option_code = ''OWN_ONLY'')';

Line: 291

       select 1
	   into l_count
       from ZX_SUBSCRIPTION_DETAILS det
       where det.first_pty_org_id = p_first_party_org_id
    	 and det.tax_regime_code = p_tax_regime_code
         and det.view_options_code = 'VFC';

Line: 299

       select 1
	   into l_count
       from ZX_SUBSCRIPTION_DETAILS det
       where det.first_pty_org_id = p_first_party_org_id
         and det.tax_regime_code = p_tax_regime_code
         and det.view_options_code = 'VFC';

Line: 345

                        (select tax_regime_code
                         from ZX_SUBSCRIPTION_DETAILS det
                         where det.first_pty_org_id = nvl(SYS_CONTEXT(''my_ctx'',''FIRSTPTYORGID'') ,-999) )';