APPS.PV_ATTRIBUTE_UTIL dependencies on FND_CURRENCIES_VL

Line 196: select name into l_curr_value from fnd_currencies_vl

192:
193: begin
194: l_curr_code := SUBSTR(l_attr_value, INSTR(l_attr_value, ':::') + 3,INSTR(l_attr_value, ':::', 1, 2) - (INSTR(l_attr_value, ':::') + 3));
195:
196: select name into l_curr_value from fnd_currencies_vl
197: where currency_code=l_curr_code;
198:
199:
200:

Line 649: select name into l_curr_value from fnd_currencies_vl

645: begin
646: if(l_display_external_value_flag = 'N') then
647: l_curr_code := l_value || SUBSTR(l_attr_value, INSTR(l_attr_value, ':::') + 3,INSTR(l_attr_value, ':::', 1, 2) - (INSTR(l_attr_value, ':::') + 3));
648:
649: select name into l_curr_value from fnd_currencies_vl
650: where currency_code=l_curr_code;
651: --dbms_output.put_line('curr_val:' || l_curr_value);
652:
653:

Line 658: select name into l_curr_value from fnd_currencies_vl

654: l_value:= l_value || SUBSTR(l_attr_value, 1, INSTR(l_attr_value, ':::') - 1) ||
655: ':::' || l_curr_code || ':::' || l_curr_value || ', ';
656:
657: else
658: select name into l_curr_value from fnd_currencies_vl
659: where currency_code=gl_user_currency_code;
660:
661: l_value := l_value || pv_check_match_pub.Currency_Conversion(
662: l_attr_value,

Line 727: select name into l_curr_value from fnd_currencies_vl

723: begin
724: if(l_display_external_value_flag = 'N') then
725: l_curr_code := SUBSTR(l_attr_value, INSTR(l_attr_value, ':::') + 3,INSTR(l_attr_value, ':::', 1, 2) - (INSTR(l_attr_value, ':::') + 3));
726:
727: select name into l_curr_value from fnd_currencies_vl
728: where currency_code=l_curr_code;
729: --dbms_output.put_line('curr_val:' || l_curr_value);
730:
731:

Line 749: select name into l_curr_value from fnd_currencies_vl

745:
746: ) || ' ' || gl_user_currency_code || ', ';
747: */
748: else
749: select name into l_curr_value from fnd_currencies_vl
750: where currency_code=gl_user_currency_code;
751:
752: l_value := pv_check_match_pub.Currency_Conversion(
753: l_attr_value,