APPS.PA_CONTROL_API_PVT dependencies on FND_CURRENCIES_VL

Line 484: l_currency_code fnd_currencies_vl.currency_code%type;

480: l_po_number po_headers_all.segment1%TYPE;
481: l_header_id po_headers_all.po_header_id%TYPE;
482: l_line_id po_lines_all.po_line_id%TYPE;
483: l_line_num po_lines_all.line_num%TYPE;
484: l_currency_code fnd_currencies_vl.currency_code%type;
485: l_currency_code1 fnd_currencies_vl.currency_code%type;
486: l_currency_name fnd_currencies_vl.Name%TYPE;
487: l_project_id pa_control_items.project_id%TYPE;
488: l_ci_type_id pa_control_items.ci_type_id%type;

Line 485: l_currency_code1 fnd_currencies_vl.currency_code%type;

481: l_header_id po_headers_all.po_header_id%TYPE;
482: l_line_id po_lines_all.po_line_id%TYPE;
483: l_line_num po_lines_all.line_num%TYPE;
484: l_currency_code fnd_currencies_vl.currency_code%type;
485: l_currency_code1 fnd_currencies_vl.currency_code%type;
486: l_currency_name fnd_currencies_vl.Name%TYPE;
487: l_project_id pa_control_items.project_id%TYPE;
488: l_ci_type_id pa_control_items.ci_type_id%type;
489: l_change_description pa_ci_supplier_details.change_description%type;

Line 486: l_currency_name fnd_currencies_vl.Name%TYPE;

482: l_line_id po_lines_all.po_line_id%TYPE;
483: l_line_num po_lines_all.line_num%TYPE;
484: l_currency_code fnd_currencies_vl.currency_code%type;
485: l_currency_code1 fnd_currencies_vl.currency_code%type;
486: l_currency_name fnd_currencies_vl.Name%TYPE;
487: l_project_id pa_control_items.project_id%TYPE;
488: l_ci_type_id pa_control_items.ci_type_id%type;
489: l_change_description pa_ci_supplier_details.change_description%type;
490: l_ci_impact_id pa_ci_impacts.ci_impact_id%type := NULL;

Line 606: from fnd_currencies_vl

602: /*cursor to check the validity of currency_code*/
603: cursor c_check_currency_code(c_currency varchar2) is
604: select currency_code CurrencyCode
605: ,Name CurrencyName
606: from fnd_currencies_vl
607: where enabled_flag = 'Y'
608: and trunc(sysdate) between nvl(start_date_active,trunc(sysdate))
609: and nvl(end_date_active,trunc(sysdate))
610: and currency_code = c_currency;

Line 1713: from fnd_currencies_vl

1709:
1710: cursor validate_prj_currency(p_price_currency_code varchar2)
1711: is
1712: select currency_code
1713: from fnd_currencies_vl
1714: where enabled_flag = 'Y'
1715: and trunc(sysdate) between nvl(start_date_active,trunc(sysdate)) and nvl(end_date_active,trunc(sysdate))
1716: and currency_code = p_price_currency_code;
1717: