APPS.ARRX_SALES_TAX_REP dependencies on FND_CURRENCIES

Line 707: 'FROM fnd_currencies cy, ra_cust_trx_types types, ar_lookups lk, hz_cust_accounts c, hz_parties party '||

703: ( to_date(to_char(h_gl_date_high, 'DD-MM-YYYY'), 'DD-MM-YYYY')
704: - to_date(to_char(h_gl_date_low, 'DD-MM-YYYY'), 'DD-MM-YYYY') ) THEN
705:
706: select_trx_from :=
707: 'FROM fnd_currencies cy, ra_cust_trx_types types, ar_lookups lk, hz_cust_accounts c, hz_parties party '||
708: 'ar_vat_tax vat, ra_tax_exemptions ex, ar_lookups lk2, ar_lookups lk3, '||
709: 'ra_customer_trx_lines line, ra_customer_trx_lines tax, hz_cust_acct_sites acct_site, '||
710: 'hz_party_sites party_site, hz_loc_assignments loc_assign, hz_locations loc, ' ||
711: 'hz_cust_site_uses su, ra_customer_trx othertrx, ra_cust_trx_line_gl_dist taxdist, '||

Line 717: 'ra_tax_exemptions ex, ar_lookups lk2, ar_lookups lk3, fnd_currencies cy, '||

713: 'ra_customer_trx trx ';
714:
715: select_adj_from :=
716: 'FROM gl_code_combinations cc, ar_adjustments adj, hz_cust_accounts c, hz_parties party, ar_vat_tax vat, '||
717: 'ra_tax_exemptions ex, ar_lookups lk2, ar_lookups lk3, fnd_currencies cy, '||
718: 'ra_customer_trx_lines line, ra_customer_trx_lines tax, ra_customer_trx trx, '||
719: 'hz_cust_site_uses su, hz_cust_acct_sites acct_site, ' ||
720: 'hz_locations loc, hz_loc_assignments loc_assign, hz_party_sites party_site ';
721: ELSE

Line 723: 'FROM fnd_currencies cy, ra_cust_trx_types types, ar_lookups lk, hz_cust_accounts c, hz_parties party, '||

719: 'hz_cust_site_uses su, hz_cust_acct_sites acct_site, ' ||
720: 'hz_locations loc, hz_loc_assignments loc_assign, hz_party_sites party_site ';
721: ELSE
722: select_trx_from :=
723: 'FROM fnd_currencies cy, ra_cust_trx_types types, ar_lookups lk, hz_cust_accounts c, hz_parties party, '||
724: 'ar_vat_tax vat, ra_tax_exemptions ex, ar_lookups lk2, ar_lookups lk3, '||
725: 'ra_customer_trx_lines line, ra_customer_trx_lines tax, ' ||
726: ' hz_cust_acct_sites acct_site, hz_locations loc, hz_loc_assignments loc_assign, hz_party_sites party_site, '||
727: 'hz_cust_site_uses su, ra_customer_trx othertrx, ra_cust_trx_line_gl_dist taxdist, '||

Line 733: 'ra_tax_exemptions ex, ar_lookups lk2, ar_lookups lk3, fnd_currencies cy, '||

729: 'ra_customer_trx trx,ra_cust_trx_line_gl_dist dist ';
730:
731: select_adj_from :=
732: 'FROM hz_cust_accounts c, hz_parties party, ar_vat_tax vat, '||
733: 'ra_tax_exemptions ex, ar_lookups lk2, ar_lookups lk3, fnd_currencies cy, '||
734: 'ra_customer_trx_lines line, ra_customer_trx_lines tax, ra_customer_trx trx, '||
735: 'hz_cust_site_uses su, hz_cust_acct_sites acct_site, hz_party_sites party_site, ' ||
736: 'hz_locations loc, hz_loc_assignments loc_assign, gl_code_combinations cc, ar_adjustments adj ';
737: END IF;

Line 2260: from fnd_currencies

2256: BEGIN
2257:
2258: select nvl(precision,0), minimum_accountable_unit
2259: into c_precision, c_mau
2260: from fnd_currencies
2261: where currency_code = fc_currency;
2262:
2263: fc_precision := c_precision;
2264: if c_mau is null then