DBA Data[Home] [Help]

APPS.PO_CURRENCY_SV dependencies on PO_SYSTEM_PARAMETERS_ALL

Line 522: l_rate_type PO_SYSTEM_PARAMETERS_ALL.default_rate_type%TYPE;

518: l_api_name CONSTANT varchar2(30) := 'GET_CROSS_OU_RATE';
519:
520: l_from_ou_currency GL_SETS_OF_BOOKS.currency_code%TYPE;
521: l_to_ou_currency GL_SETS_OF_BOOKS.currency_code%TYPE;
522: l_rate_type PO_SYSTEM_PARAMETERS_ALL.default_rate_type%TYPE;
523: l_rate NUMBER;
524: l_display_rate NUMBER;
525: l_return_status VARCHAR2(1);
526: l_message_name VARCHAR2(100);

Line 558: from po_system_parameters_all psp

554:
555: -- Get the default rate type from the To OU.
556: select default_rate_type
557: into l_rate_type
558: from po_system_parameters_all psp
559: where nvl(psp.org_id, -99) = nvl(p_to_ou_id, -99);
560:
561: l_progress := '020';
562: