APPS.ZX_SECURITY dependencies on ZX_SUBSCRIPTION_DETAILS

Line 44: from ZX_SUBSCRIPTION_DETAILS

40: BEGIN
41:
42: D_predicate := '(content_owner_id,tax_regime_code) IN
43: (select parent_first_pty_org_id, tax_regime_code
44: from ZX_SUBSCRIPTION_DETAILS
45: where view_options_code in (''NONE'',''VFC'',''VFR'')
46: and SYS_CONTEXT(''my_ctx'',''EFFECTIVEDATE'') between effective_from and
47: nvl(effective_to, SYS_CONTEXT(''my_ctx'',''EFFECTIVEDATE'')) and first_pty_org_id = nvl(SYS_CONTEXT(''my_ctx'',''FIRSTPTYORGID''),-999)) ';
48:

Line 128: from ZX_SUBSCRIPTION_DETAILS det,

124:
125: IF fnd_profile.value ('ZX_GCO_WRITE_ACCESS') = 'Y' then
126: D_predicate := '(content_owner_id, tax_regime_code) IN
127: (select det.parent_first_pty_org_id, det.tax_regime_code
128: from ZX_SUBSCRIPTION_DETAILS det,
129: ZX_FIRST_PARTY_ORGANIZATIONS_V ptp
130: where det.first_pty_org_id = ptp.party_tax_profile_id)
131: or content_owner_id = -99';
132: ELSE

Line 135: from ZX_SUBSCRIPTION_DETAILS det,

131: or content_owner_id = -99';
132: ELSE
133: D_predicate := '(content_owner_id, tax_regime_code) IN
134: (select det.parent_first_pty_org_id, det.tax_regime_code
135: from ZX_SUBSCRIPTION_DETAILS det,
136: ZX_FIRST_PARTY_ORGANIZATIONS_V ptp
137: where det.first_pty_org_id = ptp.party_tax_profile_id)';
138: END IF;
139: RETURN D_predicate;

Line 199: from ZX_SUBSCRIPTION_DETAILS det,

195: BEGIN
196: IF fnd_profile.value('ZX_GCO_WRITE_ACCESS') = 'Y' then
197: D_predicate := '(content_owner_id, tax_regime_code) IN
198: (select parent_first_pty_org_id, tax_regime_code
199: from ZX_SUBSCRIPTION_DETAILS det,
200: ZX_FIRST_PARTY_ORGANIZATIONS_V ptp
201: where det.first_pty_org_id = ptp.party_tax_profile_id
202: and det.view_options_code = ''VFC'')
203: or content_owner_id = -99';

Line 207: from ZX_SUBSCRIPTION_DETAILS det,

203: or content_owner_id = -99';
204: ELSE
205: D_predicate := '(content_owner_id, tax_regime_code) IN
206: (select parent_first_pty_org_id, tax_regime_code
207: from ZX_SUBSCRIPTION_DETAILS det,
208: ZX_FIRST_PARTY_ORGANIZATIONS_V ptp
209: where det.first_pty_org_id = ptp.party_tax_profile_id
210: and det.view_options_code = ''VFC'')';
211: END IF;

Line 293: from ZX_SUBSCRIPTION_DETAILS det

289: IF fnd_profile.value('ZX_GCO_WRITE_ACCESS') = 'Y' then
290: IF p_first_party_org_id <> -99 then
291: select 1
292: into l_count
293: from ZX_SUBSCRIPTION_DETAILS det
294: where det.first_pty_org_id = p_first_party_org_id
295: and det.tax_regime_code = p_tax_regime_code
296: and det.view_options_code = 'VFC';
297: END IF;

Line 301: from ZX_SUBSCRIPTION_DETAILS det

297: END IF;
298: ELSE
299: select 1
300: into l_count
301: from ZX_SUBSCRIPTION_DETAILS det
302: where det.first_pty_org_id = p_first_party_org_id
303: and det.tax_regime_code = p_tax_regime_code
304: and det.view_options_code = 'VFC';
305: END IF;

Line 346: from ZX_SUBSCRIPTION_DETAILS det

342: D_predicate VARCHAR2 (2000);
343: BEGIN
344: D_predicate := '(tax_regime_code) IN
345: (select tax_regime_code
346: from ZX_SUBSCRIPTION_DETAILS det
347: where det.first_pty_org_id = nvl(SYS_CONTEXT(''my_ctx'',''FIRSTPTYORGID'') ,-999) )';
348: RETURN D_predicate;
349: END single_regime_access;
350: