APPS.ZX_ON_DEMAND_TRX_UPGRADE_PKG dependencies on DUAL

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

246: IS
247:
248: l_worker_id number;
249: l_product varchar2(30) ;
250: l_table_name varchar2(30) := 'dual';
251: l_status varchar2(30);
252: l_industry varchar2(30);
253: l_retstatus boolean;
254: l_table_owner varchar2(30);

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

5440: AND recdist.tax_rate_id(+) = pohzd.tax_rate_id
5441: ) pohzd,
5442: fnd_currencies fc,
5443: zx_rates_b rates,
5444: (SELECT 'Y' rec_flag FROM dual UNION ALL SELECT 'N' rec_flag FROM dual) tmp
5445: WHERE pohzd.trx_currency_code = fc.currency_code(+)
5446: AND rates.tax_regime_code(+) = pohzd.tax_regime_code
5447: AND rates.tax(+) = pohzd.tax
5448: AND rates.content_owner_id(+) = pohzd.content_owner_id