356: l_conv_type VARCHAR2(10);
357:
358: BEGIN
359: -- Bug 3714173: Retrieve the reporting currency
360: l_to_currency := nvl(fnd_profile.value('IBY_DBC_REPORTING_CURRENCY'), 'USD');
361:
362: l_conv_type := fnd_profile.value('IBY_DBC_REPORTING_CURR_CONV_RATE_TYPE');
363:
364: -- Set the payee value accordingly.
358: BEGIN
359: -- Bug 3714173: Retrieve the reporting currency
360: l_to_currency := nvl(fnd_profile.value('IBY_DBC_REPORTING_CURRENCY'), 'USD');
361:
362: l_conv_type := fnd_profile.value('IBY_DBC_REPORTING_CURR_CONV_RATE_TYPE');
363:
364: -- Set the payee value accordingly.
365: IF( payee_id is NULL ) THEN
366: l_payeeId := '%';
667: l_conv_type VARCHAR2(10);
668:
669: BEGIN
670: -- Bug 3714173: Retrieve the reporting currency
671: l_to_currency := nvl(fnd_profile.value('IBY_DBC_REPORTING_CURRENCY'), 'USD');
672:
673: l_conv_type := fnd_profile.value('IBY_DBC_REPORTING_CURR_CONV_RATE_TYPE');
674:
675: -- Set the payee value accordingly.
669: BEGIN
670: -- Bug 3714173: Retrieve the reporting currency
671: l_to_currency := nvl(fnd_profile.value('IBY_DBC_REPORTING_CURRENCY'), 'USD');
672:
673: l_conv_type := fnd_profile.value('IBY_DBC_REPORTING_CURR_CONV_RATE_TYPE');
674:
675: -- Set the payee value accordingly.
676: IF( payee_id is NULL ) THEN
677: l_payeeId := '%';
891: l_conv_type VARCHAR2(10);
892:
893: BEGIN
894: -- Bug 3714173: Retrieve the reporting currency
895: l_to_currency := nvl(fnd_profile.value('IBY_DBC_REPORTING_CURRENCY'), 'USD');
896:
897: l_conv_type := fnd_profile.value('IBY_DBC_REPORTING_CURR_CONV_RATE_TYPE');
898:
899: -- Set the payee value accordingly.
893: BEGIN
894: -- Bug 3714173: Retrieve the reporting currency
895: l_to_currency := nvl(fnd_profile.value('IBY_DBC_REPORTING_CURRENCY'), 'USD');
896:
897: l_conv_type := fnd_profile.value('IBY_DBC_REPORTING_CURR_CONV_RATE_TYPE');
898:
899: -- Set the payee value accordingly.
900: IF( payee_id is NULL ) THEN
901: l_payeeId := '%';
1016: l_conv_type VARCHAR2(10);
1017:
1018: BEGIN
1019: -- Bug 3714173: Retrieve the reporting currency
1020: l_to_currency := nvl(fnd_profile.value('IBY_DBC_REPORTING_CURRENCY'), 'USD');
1021:
1022: l_conv_type := fnd_profile.value('IBY_DBC_REPORTING_CURR_CONV_RATE_TYPE');
1023:
1024: -- Set the payee value accordingly.
1018: BEGIN
1019: -- Bug 3714173: Retrieve the reporting currency
1020: l_to_currency := nvl(fnd_profile.value('IBY_DBC_REPORTING_CURRENCY'), 'USD');
1021:
1022: l_conv_type := fnd_profile.value('IBY_DBC_REPORTING_CURR_CONV_RATE_TYPE');
1023:
1024: -- Set the payee value accordingly.
1025: IF( payee_id is NULL ) THEN
1026: l_payeeId := '%';