APPS.OE_CREDIT_EXPOSURE_PVT dependencies on OE_CREDIT_CHECK_RULES

Line 103: g_conversion_type OE_Credit_Check_Rules.conversion_type%TYPE;

99: b48 NUMBER;
100: --TaxER end
101:
102: g_error_curr_tbl OE_CREDIT_CHECK_UTIL.curr_tbl_type;
103: g_conversion_type OE_Credit_Check_Rules.conversion_type%TYPE;
104: g_functional_currency FND_CURRENCIES.Currency_code%TYPE;
105: g_use_party_hierarchy VARCHAR2(1) ;
106:
107: --g_external_exposure NUMBER ;

Line 5305: FROM oe_credit_check_rules

5301: SELECT
5302: orders_on_hold_flag
5303: , maximum_days_past_due
5304: , nvl(incl_freight_charges_flag, 'N') incl_freight_charges_flag
5305: FROM oe_credit_check_rules
5306: WHERE nvl(quick_cr_check_flag, 'N') = 'Y'
5307: AND sysdate between nvl(start_date_active, sysdate)
5308: and nvl(end_date_active, sysdate);
5309: 14689044 end*/

Line 5314: FROM oe_credit_check_rules

5310: --14689044 start
5311: CURSOR credit_check_rules
5312: IS
5313: SELECT *
5314: FROM oe_credit_check_rules
5315: WHERE NVL(quick_cr_check_flag, 'N') = 'Y'
5316: AND sysdate between nvl(start_date_active, sysdate)
5317: and nvl(end_date_active, sysdate);
5318: --14689044 end

Line 5484: where not exists ( select 1 from oe_credit_check_rules where credit_check_level_code = 'ORDER' and quick_cr_check_flag= 'Y');

5480: begin
5481: select 'N'
5482: into l_cc_level_flag
5483: from dual
5484: where not exists ( select 1 from oe_credit_check_rules where credit_check_level_code = 'ORDER' and quick_cr_check_flag= 'Y');
5485: exception
5486: when others then
5487: l_cc_level_flag:='Y';
5488: end;