APPS.OE_OE_FORM_HEADER dependencies on AR_SYSTEM_PARAMETERS

Line 4032: l_AR_Sys_Param_Rec AR_SYSTEM_PARAMETERS_ALL%ROWTYPE;

4028: l_sql_stmt VARCHAR2(2000);
4029: l_area_code_length Number;
4030: l_filtered_phone_number Varchar2(300);
4031: l_phone_format Varchar2(300);
4032: l_AR_Sys_Param_Rec AR_SYSTEM_PARAMETERS_ALL%ROWTYPE;
4033:
4034: BEGIN
4035: oe_debug_pub.add('Entering OE_OE_FORM_HEADER.Validate_Phone_Number', 1);
4036: IF OE_OE_FORM_HEADER.G_HZ_H_Installed IS NULL THEN

Line 4080: from ar_system_parameters;

4076:
4077: IF l_user_territory_code IS NULL THEN
4078: IF oe_code_control.code_release_level < '110510' THEN
4079: select default_country into l_user_territory_code
4080: from ar_system_parameters;
4081: ELSE
4082: l_AR_Sys_Param_Rec := OE_Sys_Parameters_Pvt.Get_AR_Sys_Params;
4083: l_user_territory_code:= l_AR_Sys_Param_Rec.default_country;
4084: END IF;