APPS.MST_AUDIT_REP_EXCP dependencies on MST_PARAMETERS

Line 1921: FROM MST_PARAMETERS mgp, WSH_GLOBAL_PARAMETERS wgp, MST_PARAMETERS mup

1917: --Code adapted from snapshot "/mstdev/mst/11.5/src/snap/mstsplno.ppc" to obtain avg_driving_speed and distance_scale_factor
1918: BEGIN
1919: SELECT nvl(wgp.AVG_HWAY_SPEED,'-99') , nvl(wgp.TL_HWAY_DIS_EMP_CONSTANT,'-99'), wgp.GU_DISTANCE_UOM, wgp.TIME_UOM
1920: INTO lAvgHwayDist, lDisConstant, lDistanceUomCode, lTimeUomCode
1921: FROM MST_PARAMETERS mgp, WSH_GLOBAL_PARAMETERS wgp, MST_PARAMETERS mup
1922: WHERE mgp.user_id = -9999
1923: and mup.user_id = user_idIn
1924: and rownum = 1;
1925: EXCEPTION

Line 1931: FROM MST_PARAMETERS mgp, WSH_GLOBAL_PARAMETERS wgp

1927: BEGIN
1928: debug_output('first select gave no results in parameters query');
1929: SELECT nvl(wgp.AVG_HWAY_SPEED,'-99'), nvl(wgp.TL_HWAY_DIS_EMP_CONSTANT,'-99'), wgp.GU_DISTANCE_UOM, wgp.TIME_UOM
1930: INTO lAvgHwayDist, lDisConstant, lDistanceUomCode, lTimeUomCode
1931: FROM MST_PARAMETERS mgp, WSH_GLOBAL_PARAMETERS wgp
1932: WHERE mgp.user_id = -9999
1933: and rownum = 1;
1934: EXCEPTION
1935: WHEN NO_DATA_FOUND THEN