DBA Data[Home] [Help]

APPS.IBY_DBCCARD_PVT dependencies on FND_PROFILE

Line 358: l_to_currency := nvl(fnd_profile.value('IBY_DBC_REPORTING_CURRENCY'), 'USD');

354: l_to_currency VARCHAR2(10);
355:
356: BEGIN
357: -- Bug 3714173: Retrieve the reporting currency
358: l_to_currency := nvl(fnd_profile.value('IBY_DBC_REPORTING_CURRENCY'), 'USD');
359:
360: -- Set the payee value accordingly.
361: IF( payee_id is NULL ) THEN
362: l_payeeId := '%';

Line 665: l_to_currency := nvl(fnd_profile.value('IBY_DBC_REPORTING_CURRENCY'), 'USD');

661: l_to_currency VARCHAR2(10);
662:
663: BEGIN
664: -- Bug 3714173: Retrieve the reporting currency
665: l_to_currency := nvl(fnd_profile.value('IBY_DBC_REPORTING_CURRENCY'), 'USD');
666:
667: -- Set the payee value accordingly.
668: IF( payee_id is NULL ) THEN
669: l_payeeId := '%';

Line 885: l_to_currency := nvl(fnd_profile.value('IBY_DBC_REPORTING_CURRENCY'), 'USD');

881: l_to_currency VARCHAR2(10);
882:
883: BEGIN
884: -- Bug 3714173: Retrieve the reporting currency
885: l_to_currency := nvl(fnd_profile.value('IBY_DBC_REPORTING_CURRENCY'), 'USD');
886:
887: -- Set the payee value accordingly.
888: IF( payee_id is NULL ) THEN
889: l_payeeId := '%';

Line 1006: l_to_currency := nvl(fnd_profile.value('IBY_DBC_REPORTING_CURRENCY'), 'USD');

1002: l_to_currency VARCHAR2(10);
1003:
1004: BEGIN
1005: -- Bug 3714173: Retrieve the reporting currency
1006: l_to_currency := nvl(fnd_profile.value('IBY_DBC_REPORTING_CURRENCY'), 'USD');
1007:
1008: -- Set the payee value accordingly.
1009: IF( payee_id is NULL ) THEN
1010: l_payeeId := '%';