DBA Data[Home] [Help]

APPS.CN_SRP_PERIOD_QUOTAS_PKG dependencies on FND_CURRENCIES

Line 979: from cn_repositories r, gl_sets_of_books b, fnd_currencies c,

975: BEGIN
976:
977: -- get precision
978: select c.extended_precision INTO g_ext_precision
979: from cn_repositories r, gl_sets_of_books b, fnd_currencies c,
980: cn_srp_period_quotas spq
981: where r.org_id = spq.org_id
982: and r.set_of_books_id = b.set_of_books_id
983: and b.currency_code = c.currency_code

Line 1600: from cn_repositories r, gl_sets_of_books b, fnd_currencies c,

1596: BEGIN
1597:
1598: -- get precision
1599: select c.extended_precision INTO g_ext_precision
1600: from cn_repositories r, gl_sets_of_books b, fnd_currencies c,
1601: cn_srp_quota_assigns sqa
1602: where r.org_id = sqa.org_id
1603: and r.set_of_books_id = b.set_of_books_id
1604: and b.currency_code = c.currency_code