869:
870: -- --------------------------
871: -- initialize profile value
872: -- --------------------------
873: g_spread_load := NVL(FND_PROFILE.VALUE('CRP_SPREAD_LOAD'), SYS_NO);
874: g_hour_uom := fnd_profile.value('BOM:HOUR_UOM_CODE');
875:
876: -- --------------------------
877: -- initialize query id
870: -- --------------------------
871: -- initialize profile value
872: -- --------------------------
873: g_spread_load := NVL(FND_PROFILE.VALUE('CRP_SPREAD_LOAD'), SYS_NO);
874: g_hour_uom := fnd_profile.value('BOM:HOUR_UOM_CODE');
875:
876: -- --------------------------
877: -- initialize query id
878: -- --------------------------