APPS.OE_OE_FORM_HEADER dependencies on AR_SYSTEM_PARAMETERS

Line 4035: l_AR_Sys_Param_Rec AR_SYSTEM_PARAMETERS_ALL%ROWTYPE;

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

Line 4083: from ar_system_parameters;

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