[Home] [Help]
85: b35 NUMBER;
86: b36 NUMBER;
87:
88: g_error_curr_tbl OE_CREDIT_CHECK_UTIL.curr_tbl_type;
89: g_conversion_type OE_Credit_Check_Rules.conversion_type%TYPE;
90: g_functional_currency FND_CURRENCIES.Currency_code%TYPE;
91: g_use_party_hierarchy VARCHAR2(1) ;
92:
93: --g_external_exposure NUMBER ;
4950: SELECT
4951: orders_on_hold_flag
4952: , maximum_days_past_due
4953: , nvl(incl_freight_charges_flag, 'N') incl_freight_charges_flag
4954: FROM oe_credit_check_rules
4955: WHERE nvl(quick_cr_check_flag, 'N') = 'Y'
4956: AND sysdate between nvl(start_date_active, sysdate)
4957: and nvl(end_date_active, sysdate);
4958: