APPS.ZX_ON_DEMAND_TRX_UPGRADE_PKG dependencies on DUAL

Line 254: l_table_name varchar2(30) := 'dual';

250: IS
251:
252: l_worker_id number;
253: l_product varchar2(30) ;
254: l_table_name varchar2(30) := 'dual';
255: l_status varchar2(30);
256: l_industry varchar2(30);
257: l_retstatus boolean;
258: l_table_owner varchar2(30);

Line 6303: (SELECT 'Y' rec_flag FROM dual UNION ALL SELECT 'N' rec_flag FROM dual) tmp

6299: AND recdist.tax_rate_id(+) = pohzd.tax_rate_id
6300: ) pohzd,
6301: fnd_currencies fc,
6302: zx_rates_b rates,
6303: (SELECT 'Y' rec_flag FROM dual UNION ALL SELECT 'N' rec_flag FROM dual) tmp
6304: WHERE pohzd.trx_currency_code = fc.currency_code(+)
6305: AND rates.tax_regime_code(+) = pohzd.tax_regime_code
6306: AND rates.tax(+) = pohzd.tax
6307: AND rates.content_owner_id(+) = pohzd.content_owner_id