APPS.POA_SAVINGS_NP dependencies on EDW_LOCAL_SYSTEM_PARAMETERS

Line 56: v_edw_global_rate_type edw_local_system_parameters.rate_type%type;

52: l_end_time DATE;
53: v_ship_to_organization_id po_line_locations_all.ship_to_organization_id%type;
54: v_ship_to_ou NUMBER;
55: v_rate_date DATE;
56: v_edw_global_rate_type edw_local_system_parameters.rate_type%type;
57: v_edw_global_currency_code EDW_LOCAL_SYSTEM_PARAMETERS.warehouse_currency_code%type;
58: --
59: /* cursor to look at all standard POs which non-one-time-items that exist
60: * in blankets. We still need to check whether all the criteria

Line 57: v_edw_global_currency_code EDW_LOCAL_SYSTEM_PARAMETERS.warehouse_currency_code%type;

53: v_ship_to_organization_id po_line_locations_all.ship_to_organization_id%type;
54: v_ship_to_ou NUMBER;
55: v_rate_date DATE;
56: v_edw_global_rate_type edw_local_system_parameters.rate_type%type;
57: v_edw_global_currency_code EDW_LOCAL_SYSTEM_PARAMETERS.warehouse_currency_code%type;
58: --
59: /* cursor to look at all standard POs which non-one-time-items that exist
60: * in blankets. We still need to check whether all the criteria
61: * for the item match those stated in the blankets.

Line 602: from edw_local_system_parameters;

598: rate_type
599: into
600: v_edw_global_currency_code,
601: v_edw_global_rate_type
602: from edw_local_system_parameters;
603: if( v_edw_global_currency_code is null
604: or v_edw_global_rate_type is null
605: )
606: then

Line 958: p_rate_type edw_local_system_parameters.rate_type%type) RETURN NUMBER

954:
955: FUNCTION get_currency_conv_rate (p_from_currency_code po_headers_all.currency_code%type,
956: p_to_currency_code VARCHAR2,
957: p_rate_date DATE,
958: p_rate_type edw_local_system_parameters.rate_type%type) RETURN NUMBER
959: IS
960: BEGIN
961:
962: if(p_from_currency_code = l_from_currency_code